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

    Calculate Revenue of the top 10% PERCENT

    Samuel Lin

      Hello Qlikers,

       

      In a straight table, I have a dimension such as

       

      Quartername([date])

       

      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!!

       

      Samuel