topic Re: Displaying last records value in pivot in QlikView

Displaying last records value in pivot

ajaysingh29 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I would like to show item desc wise last unit cost in the Piovt table.

I have attached test QVW file, requesting your suggestions to achieve this.

Many Thanks!

prma7799 — Mon, 04 Dec 2017 11:24:12 GMT

Check this??

ajaysingh29 — Mon, 04 Dec 2017 11:58:30 GMT

Thanks for your reply.

Tried below, but not showing proper result. Could you help plz help me out with this.

Based on the data which is shared in qvw result should show :

Gpc = 240

GCC=230

INCC=15500

UPS=660

Thanks!

tresB — Mon, 04 Dec 2017 12:04:22 GMT

Try this:

FirstSortedValue(DISTINCT UnitCost, -SubField([PO Number],'-',-1))

ajaysingh29 — Mon, 04 Dec 2017 12:19:05 GMT

Thank You!!