topic firstsortedvalue and P() in QlikView

firstsortedvalue and P()

Mon, 26 Jan 2015 21:01:41 GMT

How can I combine these:

avg(aggr(firstsortedvalue(value,-date),Client))

Client = P({1<order={2}>} Client)

Hope someone can help!

liivi

Anonymous — Mon, 26 Jan 2015 21:08:20 GMT

Did you try this?

avg({<Client = P({1<order={2}>}>} aggr(firstsortedvalue(value,-date),Client))

MarcoWedel — Mon, 26 Jan 2015 22:26:04 GMT

Hi,

maybe one solution could be:

=avg(aggr(firstsortedvalue({$<Client = P({1<order={2}>} Client)>} value,-date),Client))

hope this helps

regards

Marco