topic Excluding a specific row from an Excel spread sheet in QlikView

Excluding a specific row from an Excel spread sheet

Anonymous — Mon, 18 Nov 2013 20:35:20 GMT

Hello,

I have an Excel spread sheet that I am loading my data from. It has multiple rows and columns. The very last row in the spread sheet is a totals row, where all the data from the columns is summed up. When making graphs this row skews the results, so is there any way to take it out using the script? Or is it best to just remove the row from the spreadsheet all together?

Thank you for you help,

- Joe

Re: Excluding a specific row from an Excel spread sheet

Mon, 18 Nov 2013 21:18:06 GMT

Hi Joe,

You can remove the row by including a where clause in the script.

In my case the label for the total row is 'total'

Go to File>Edit Script

insert the where clause prior to the ;

e.g.

LOAD A,

FROM

D:\datawithtotal.xls.xlsx

(ooxml, no labels)

where A<>'total';

hope this helps,

Re: Excluding a specific row from an Excel spread sheet

Anonymous — Mon, 18 Nov 2013 21:22:53 GMT

Thank you! My problem was I didn't realize that pesky semi-colon was the end of the script so when I tried to type in WHERE before it gave me problems. Thank you for your help!