Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

datanibbler
Esteemed Contributor

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

Community Browser