topic Add the values from several lines in a file in QlikView https://community.qlik.com/t5/QlikView/Add-the-values-from-several-lines-in-a-file/m-p/396274#M694397 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P>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.</P><P></P><P>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?</P><P></P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Wed, 22 May 2013 15:26:14 GMT datanibbler 2013-05-22T15:26:14Z Add the values from several lines in a file https://community.qlik.com/t5/QlikView/Add-the-values-from-several-lines-in-a-file/m-p/396274#M694397 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P>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.</P><P></P><P>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?</P><P></P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Wed, 22 May 2013 15:26:14 GMT https://community.qlik.com/t5/QlikView/Add-the-values-from-several-lines-in-a-file/m-p/396274#M694397 datanibbler 2013-05-22T15:26:14Z