Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Number Merchants 80% Sales

Hi,

I would like to see the number of merchants responsible for 80% of revenue over time. The idea is to see which proportion of our customers provide 80 percent of our revenue and how this figure evolves over time. There are numerous posts dealing with this topic, but so far I have been unable to get them to work in my context.

So far, I've used the fractile function to create a limit over which I want to see the count of customers. Then I use a count/if conditional statement to query the count, but this is not working. I've attached an example qvw. If anyone has the time to take a look, it would be very much appreciated.

Best,

Matt

1 Reply
danielrozental
Master II
Master II

Matt, if you're using QV10 just use the action "Pareto Select" in a button.