QlikView Essentials

Loading EmployeeSalesTarget.xlsx

We will load EmployeeSalesTarget.xlsx using Crosstable because it is in the Crosstable format:

1. Open QlikViewEssentials_Chap3.qvw and save it as QlikViewEssentials_Chap4_Crosstable.qvw.
2. Go to the script editor and create a new tab and call it Crosstable.
3. Click on Table Files and browse to EmployeeSalesTarget.xlsx. Check all the default settings and click on Next.
4. Click Next.
5. Under File Wizard: Options, click on Crosstable under Prefixes.
   
6. Select the Qualifier Fields, Attribute Field, and Data Field. Qualifier fields are columns on the left. You can specify any number of qualifiers. Attribute and data fields can have any ...