Crosstable essentials
In your downloaded folder, look at EmployeeSalesTarget.xls. This file is located in C:\QlikViewEssentials\Data.
Some of the properties of this file are as follows:
- A file of this format is called a Crosstable. A Crosstable is a special format of data in which some of the fields are displayed in rows and some in columns.
- If this table is loaded in QlikView using a regular load statement, it will load each of the fields separately.
- The problem with this kind of structure is that the table can grow very large, if each of the fields is stored separately. Performing aggregation on such a table will be difficult. You have do to Sum(2005) + Sum(2006) … to get the total sales.
- It would be better for QlikView applications to load a table in the following format:
In this format, the aggregation of data will be much easier.
- Use the cross table prefix to load a cross table in QlikView.
