topic Re: Get last sorted record in QlikView

Get last sorted record

mato32188 — Mon, 19 May 2014 07:38:07 GMT

Hello guys,

I would like to create a pivot table in which you can get the last balance of product and its version as the last value of all values. See in my attached xls file. One product and its version could be located at more than one Place and also within Place in more than one PlacePoint.

Dont need to know last balance of the day, only get last balance of product and its version.

Final Pivot:

Product ProductVer balance= calculated as a sum of balances at all places and placepoints

L111 ver1 200pce

L111 ver2 150pce

L133 ver1 20pce

I tried to use the firstsortedvalue, but it returns some other values i want to get.

Thanks for your help,

Martin

Re: Get last sorted record

tresB — Mon, 19 May 2014 07:45:33 GMT

Did you try = FirstSortedValue(Balance, -Timestamp) ?

Re: Get last sorted record

Mon, 19 May 2014 07:49:26 GMT

Let me know if i'am correct:

you would like for product+version find sum of last balances from each place+placepoint?

regards

Darek

Re: Get last sorted record

mato32188 — Mon, 19 May 2014 08:03:00 GMT

Lets say, I would like to sum up all last balances at different placepoints for each Product and its version...

Need to find last Balance for each product and ist version, does not matter, where it is located...

Like for Purchase, you need to know the last balance of Purchase Product, no matter, where it is.

Re: Get last sorted record

Mon, 19 May 2014 08:15:51 GMT

ok i will try to help you....

Re: Get last sorted record

mato32188 — Mon, 19 May 2014 08:16:45 GMT

Helpful, it returns last balance of Product and its version sorted by timestamp descending, am I right?

But I need to know all last values for those products and versions, that could be located in different places and placepoints. Find last records for Product and its version at different Places and PlacePoints and sum up those balances.

Re: Get last sorted record

mato32188 — Mon, 19 May 2014 08:17:56 GMT

Dziękuję bardzo

Re: Re: Get last sorted record

Mon, 19 May 2014 08:21:24 GMT

try this,

regards

Darek

Re: Re: Get last sorted record

mato32188 — Mon, 19 May 2014 08:28:31 GMT

Did you upload anything Dariusz?

I cant see it.

Re: Re: Get last sorted record

Mon, 19 May 2014 08:57:20 GMT

i attached example.

Re: Re: Get last sorted record

Mon, 19 May 2014 08:57:47 GMT

Look on post sended May 19, 2014 4:21 AM