topic Percentage Woes in QlikView https://community.qlik.com/t5/QlikView/Percentage-Woes/m-p/452714#M1162170 <HTML><HEAD></HEAD><BODY><P>Hello QlikCommunity,</P><P></P><P>I'm struggling a bit with displaying my figures as a percentage, and have two questions on this. I'll try to be succinct:</P><P></P><P>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.</P><P>&nbsp;&nbsp;&nbsp; count(ID) / (if(aggr(rank(count(ID)),Category)&lt;=5, count(ID)))</P><P></P><P>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.</P></BODY></HTML> Wed, 19 Dec 2012 15:36:59 GMT 2012-12-19T15:36:59Z Percentage Woes https://community.qlik.com/t5/QlikView/Percentage-Woes/m-p/452714#M1162170 <HTML><HEAD></HEAD><BODY><P>Hello QlikCommunity,</P><P></P><P>I'm struggling a bit with displaying my figures as a percentage, and have two questions on this. I'll try to be succinct:</P><P></P><P>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.</P><P>&nbsp;&nbsp;&nbsp; count(ID) / (if(aggr(rank(count(ID)),Category)&lt;=5, count(ID)))</P><P></P><P>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.</P></BODY></HTML> Wed, 19 Dec 2012 15:36:59 GMT https://community.qlik.com/t5/QlikView/Percentage-Woes/m-p/452714#M1162170 2012-12-19T15:36:59Z