O'Reilly logo

QlikView Essentials by Chandraish Sinha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.
    Loading EmployeeSalesTarget.xlsx
  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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required