Discussion Board for collaboration related to QlikView App Development.
I have the following spreadhseet. I simply want to return the row with the last 'Sales' value. So in this case it should return
What would be the best way ?
In the script or the front end?
in the script
LOAD RowNo() as RowNum,
(ooxml, embedded labels, table is Sheet1)
Where Len(Trim(SALES)) > 0;
Right Join (Table)
LOAD Max(RowNum) as RowNum