topic Number Merchants 80% Sales in QlikView https://community.qlik.com/t5/QlikView/Number-Merchants-80-Sales/m-p/263193#M1189176 <HTML><HEAD></HEAD><BODY><P>Matt, if you're using QV10 just use the action "Pareto Select" in a button.</P></BODY></HTML> Wed, 14 Sep 2011 23:10:55 GMT danielrozental 2011-09-14T23:10:55Z Number Merchants 80% Sales https://community.qlik.com/t5/QlikView/Number-Merchants-80-Sales/m-p/263192#M1189175 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Best,</P><P></P><P>Matt</P></BODY></HTML> Wed, 14 Sep 2011 21:34:09 GMT https://community.qlik.com/t5/QlikView/Number-Merchants-80-Sales/m-p/263192#M1189175 2011-09-14T21:34:09Z Number Merchants 80% Sales https://community.qlik.com/t5/QlikView/Number-Merchants-80-Sales/m-p/263193#M1189176 <HTML><HEAD></HEAD><BODY><P>Matt, if you're using QV10 just use the action "Pareto Select" in a button.</P></BODY></HTML> Wed, 14 Sep 2011 23:10:55 GMT https://community.qlik.com/t5/QlikView/Number-Merchants-80-Sales/m-p/263193#M1189176 danielrozental 2011-09-14T23:10:55Z