Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics
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
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
Thanks Edwin, that solved my problem!
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics
np