Documents related to Qlik Support.
Data from spreadsheets
Rearranging data with crosstables
Sometimes our spreadsheets aren't quite arranged the way we want for reading data into QlikView. This video shows how to use a crosstable to reformat data from spreadsheets.
Watch the video at full resolution
Download and use the files
Download the tutorial files used in this part of the tutorial.
How to use the downloaded files:
1. Unzip the file to a folder. All the files (the qvw file and the two Excel files) should go in the same folder.
2. Open the qvw file in QlikView.
3. Look at the load script in the editor to see how the example works.
Click to access the rest of the QlikView Developer Tutorial
Are you done?