0 Replies Latest reply: Dec 19, 2012 10:36 AM by Nick Confer RSS

    Percentage Woes

      Hello QlikCommunity,


      I'm struggling a bit with displaying my figures as a percentage, and have two questions on this. I'll try to be succinct:


      1. In a "Top 5" chart, how can you compute a count as a percentage of that subset? Here's my most recent failed attempt, reading other posts.

          count(ID) / (if(aggr(rank(count(ID)),Category)<=5, count(ID)))


      2. How do you see your table totals as both a count and percentage? I don't want to add a percentage expression because it is then applied to every dimension.