topic Re: Additional Row(s) To Total Row in QlikView

Additional Row(s) To Total Row

Anonymous — Mon, 21 Oct 2013 21:12:51 GMT

Is it possible to create a row in addition to Total row. For example, if I have a straight chart that has Top 10 of Clients's Sales, and I wanted to show "Top 10 as % of Total" after the Total row whose expression or formula is:

Sum of Top 10 Clients / Sum of Total * 100

Thank you for any suggestions.

Re: Additional Row(s) To Total Row

Mon, 21 Oct 2013 21:37:15 GMT

Try this in a text box:

Num(SUM({<Client = {"=RANK(AGGR(SUM(Sales),Client))<=10"}>} Sales)/Sum(TOTAL Sales),'###,###.##%')

Re: Additional Row(s) To Total Row

Anonymous — Tue, 22 Oct 2013 14:09:24 GMT

Thanks Rebecca,
I'm trying to implement this in the same chart where I show the Total.