Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Top percentage on the text box

Hi All,

I have data something like this.

PersonSales AmountCummulative Sum
A83083013.0%Top 25%Top 50%
B760159024.9%
C750234036.6%
D700304047.6%
E600364057.0%Top 75%
F500414064.8%
G450459071.8%
H400499078.1%
I350534083.6%
J300564088.3%
K250589092.2%
L200609095.3%
M150624097.7%
N100634099.2%
O506390100.0%
Total6390
If you someone select Person B, It should give us, whether that person is on to 25% or 50%, or 75%

There are multiple level of heirarchy and calendar is associated with Person, so Please help me solving on front end.

Thanks,

4 Replies
jeffmartins
Contributor II

Re: Top percentage on the text box

Hi smartech,

You need to use the constant 1 in set analysis to force qlikview to retrieve the correct value when you select person B.

See the attached file. Hope this helps you.

Regards

Not applicable

Re: Top percentage on the text box

HI Jeff,

Thank you for your response. As I wrote before, thare are many mroe dimension associated with the Person, I can not do a cummulative sum on the back end script.

Could you please think some other way?

Thanks,

jeffmartins
Contributor II

Re: Top percentage on the text box

Hi smartech,

You can create a cummulative sum in an expression as follow:

sum(aggr(rangesum(above( sum({1}[Sales Amount]),0,RowNo())),Person))

The following post http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/12/accumulative-sums contains more detail about how to create an accumulative sum.

See the file attached file. Hope this helps you.

Regards

Not applicable

Re: Top percentage on the text box

Hi Jeff,

The above example works fine for decending order of the sales amount. However, if the order is not defined properly, it is not working as desired.

Could you please advice.

Thanks,

Community Browser