Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Dimension Limits

Hi All ,

I have a scenario where i have to show the Top 10 Clients Group Percentage and Others Percentage. Am able to show the others Percentage by enabling others in Dimension Limit.

Is there any option to show the Percentage of Top 10 Clients 

Tags (2)
4 Replies
MVP & Luminary
MVP & Luminary

Re: Dimension Limits

Hi,

Can you attach sample file and your expected output?

Regards,

Jagan.

Re: Dimension Limits

Something like this? Uses two expressions, aggr(rank()) and no dimension. Add a variable and a slider if you want to dynamically change the Top N.

Best,

Peter

MVP & Luminary
MVP & Luminary

Re: Dimension Limits

Hi Senthil,

Try like this

Bar Chart

Dimension: Add calculated dimension - =IF (aggr(Rank(Sum(Amount)), Client) <= 10, 'Top 10', 'Others')

Expression: Sum(Sales) and select Relative option for getting percentage.

Hope this helps you.

Regards,

Jagan.

Re: Dimension Limits

So simple... Doh