Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Add the values from several lines in a file

Hi,

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,

DataNibbler

0 Replies