Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
Showing results for 
Search instead for 
Did you mean: 

Add the values from several lines in a file


I want to read an Excel file into QlikView - but it's only some few individual lines that I want. Moreover, it is a crosstable - with a dimension "unit" vertically and another dimension "month" horizontally.

I have made that in the first few cases by using a WHERE clause - but I can only enter one parameter for the WHERE clause every time, so I have a few separate LOADs, all of which are automatically appended by QlikView.

The actual challenge is: I have to add several lines (always the values in the same column) so it matches my requirements. How can I do that in the script?

Thanks a lot!

Best regards,


0 Replies