Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mzapparoli
Contributor
Contributor

Set Analysis issue - Get last sale by salesman

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.

 

 

 

Labels (1)
1 Solution

Accepted Solutions
edwin
Specialist III
Specialist III

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

View solution in original post

3 Replies
edwin
Specialist III
Specialist III

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

View solution in original post

mzapparoli
Contributor
Contributor
Author

Thanks Edwin, that solved my problem!

edwin
Specialist III
Specialist III

np