6 Replies Latest reply: Mar 30, 2017 3:24 AM by Samuel Lin RSS

    Calculate Revenue of the top 10% PERCENT

      Hello Qlikers,


      In a straight table, I have a dimension such as




      and for the expression, I hope to perform a calculation that shows the % of revenue contributed by the top-10%-revenue customers (the top 10% customers in that quarter since the table has the quartername as the dimension).


      I have been considering the function rank and fractile but couldn't get this an expression without error.


      One problem that makes this a bit more difficult is that revenue is calculated using set-analysis so: sum({<demension1={'xxx'}>}revenue)


      I got some ideas from https://community.qlik.com/thread/50818and Getting the top 10% of a list | Qlik Community


      I am open to all ideas, thanks, guys!!