topic Re: Dimension Limits in QlikView

Dimension Limits

Thu, 12 Feb 2015 06:57:27 GMT

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

Re: Dimension Limits

jagan — Thu, 12 Feb 2015 07:49:06 GMT

Hi,

Can you attach sample file and your expected output?

Regards,

Jagan.

Re: Dimension Limits

Peter_Cammaert — Thu, 12 Feb 2015 08:32:44 GMT

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

Re: Dimension Limits

jagan — Thu, 12 Feb 2015 08:47:45 GMT

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

Peter_Cammaert — Thu, 12 Feb 2015 08:54:37 GMT

So simple... Doh