This content has been marked as final. Show 2 replies
I am trying to import an Excel document into Qlikview. This Excel document has thousands of rows and rows 1-8 are solely used for titles. So, I want Qlikview to only look at row 9 and beyond. How can I import only rows x >=9?
(ooxml, explicit labels, table is [Source])
WHERE RowNo() >= 9;
I've also tried:
WHERE (G >= 9) but all this does is only take values in G that are greater than or equal to 9.
So far, neither of these options is working. Any help is greatly appreciated.