topic Re: set analysis not working in QlikView

set analysis not working

cafcptg2011 — Mon, 12 Jan 2015 10:33:40 GMT

Hi,

I need to know the Last Price of each article sold, but how can I accomplish that ?

I have this:

and I need this:

my current expression is:

max( { < Code = {$(=max(aggr( max(Code), Article)))} > } Price)

but as you can see above doesn't work... can anyone please help me?

thanks in advance,

cafc

mrybalko — Thu, 15 Jan 2015 16:08:10 GMT

Hello

The problem is expression like $(=max(Code)) does not take into consideration dimensions. So max Code is always 53.

I suggest to use flags in load script. Example is in attachment.

cafcptg2011 — Thu, 15 Jan 2015 16:14:57 GMT

hi,

thanks for reply/help.

on possible solution is max(code).... as simple as that...

bye

mrybalko — Wed, 21 Jan 2015 14:35:24 GMT

There is one more solution: function FirstSortedValue

So the expression is

FirstSortedValue(Price, -Code)