Set Analysis issue - Get last sale by salesman

[Zapparoli]

Hello!

I'm doing a Graph where Salesman is my dimension, and i want to get the value of the LAST sale per salesman

i Know about Max and First sorted Value Functions and they work just fine without a set analysis.

The issue is that i need to put this inside a set analysis, because i have another filter. Example:

Count({<Info={'Yes'}>} Value) /
Count({<Info={'Yes','No'}>} Value)

What i'm trying to achieve is: 

Count({<Info={'Yes'}, SalesId={'$(=Max(SalesID))'}>} Value) /
Count({<Info={'Yes','No'}, SalesId={'$(=Max(SalesID))'}>} Value)

If i do the Max(SalesID) part, i get the ID's i want to calculate, but not when inside of Set Analysis.

Thanks.

[edwin · Accepted solution]

take a look at this one:

Solved: Re: The last occurrence of the value of a group di... - Page 3 - Qlik Community - 1767104

its the same pattern - look for last occurrence based on specific dimension

[Zapparoli]

Thanks Edwin, that solved my problem!

[edwin]

np