topic Re: last value according to dimensions in QlikView

last value according to dimensions

pirotfab — Fri, 27 Sep 2019 13:37:41 GMT

Hello

I want to have the max value of the column "tps" : result = 25

I try with the attached formula that gets me a null result because I have twice a value for the same date.

do you know how to add one more criterion?

thanks

StarinieriG — Fri, 27 Sep 2019 13:50:54 GMT

Hi,

you could try with this expression

Aggr(Max(tps),date)

pirotfab — Fri, 27 Sep 2019 15:13:27 GMT

thanks for your feedback

it works for some data

I want to have the value of the field "tps" for the last production date. I do not know which expression to use

thanks

StarinieriG — Fri, 27 Sep 2019 15:41:49 GMT

Maybe it could work if you'll add a second field in this way "& of"

FirstSortedValue(total tps,-date & of)

pirotfab — Mon, 30 Sep 2019 06:54:55 GMT

Hello,

i try with this expression, but when i add a second field, that me say : "error in expression"

thanks