Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Selective Loading

Hello,

How would I perform a selective load?

For example, from an excel sheet, only loading into QlikView lines that meet the criteria Country Code = GBR?

Thanks,

Ryan

1 Solution

Accepted Solutions
Highlighted
Not applicable

When you use the table load wizard on an Excel file, you should get a Where option. It's on the Options (3rd) page under Clauses. Then use the wizard to create a Where clause to be Country Code = GBR.

Or you can just go to your existing Excel file load and add a Where like this:

...FROM
Sheet.xls
(biff, no labels, table is Sheet1$)
WHERE(CountryCode = 'GBR');


View solution in original post

1 Reply
Highlighted
Not applicable

When you use the table load wizard on an Excel file, you should get a Where option. It's on the Options (3rd) page under Clauses. Then use the wizard to create a Where clause to be Country Code = GBR.

Or you can just go to your existing Excel file load and add a Where like this:

...FROM
Sheet.xls
(biff, no labels, table is Sheet1$)
WHERE(CountryCode = 'GBR');


View solution in original post