Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Return last value

Hi

I have the following spreadhseet. I simply want to return the row with the last 'Sales' value. So in this case it should return

300, EAST

What would be the best way ?

Thanks

3 Replies
Highlighted

In the script or the front end?

Highlighted
Contributor
Contributor

in the script

Highlighted

Try this

Table:

LOAD RowNo() as RowNum,

SALES,

    REGION

FROM

[..\..\Downloads\TESTV1.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where Len(Trim(SALES)) > 0;


Right Join (Table)

LOAD Max(RowNum) as RowNum

Resident Table;