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.
