topic Re: Return last value in QlikView

Return last value

Anonymous — Wed, 02 May 2018 11:49:20 GMT

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

sunny_talwar — Wed, 02 May 2018 11:52:51 GMT

In the script or the front end?

Anonymous — Wed, 02 May 2018 13:03:14 GMT

in the script

sunny_talwar — Wed, 02 May 2018 13:07:14 GMT

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;