set analysis not working

[cafcptg2011]

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?

I have a qvw here to help you : http://community.qlik.com/servlet/JiveServlet/downloadBody/7752-102-1-10425/SalesByPrice.qvw

thanks in advance,

cafc

[mrybalko · Accepted solution]

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]

hi,

thanks for reply/help.

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

bye

[mrybalko]

There is one more solution: function FirstSortedValue

So the expression is

FirstSortedValue(Price, -Code)