Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
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