Discussion Board for collaboration related to QlikView App Development.
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?
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:
...FROMSheet.xls(biff, no labels, table is Sheet1$)WHERE(CountryCode = 'GBR');
View solution in original post