topic Re: Dimension Limit issue in Scatter Chart in QlikView

Dimension Limit issue in Scatter Chart

udaya_kumar — Thu, 03 Jul 2014 06:49:29 GMT

Hi,

I have a created a scatter chart with 1 dimension and 3 expressions.

I have given Largest 10 values from the Dimension Limit of the chart and also i have checked "Show Others" option.

I am not able to see a bubble in the chart for Others, but Others is present in the legend.

But i want even the Others as a bubble in the chart.

If i click the others from the legend, then it drill downs to the values of the dimension other than largest 10.

But i want a bubble to be shown even for Others in the chart.

How can i achieve this?

Thu, 03 Jul 2014 06:51:13 GMT

i would suggest you add a calculated dimension in this case rather than using Dimension limit.

aggr(if(rank(measure, <dimension>) <=10, dimension), "others')

udaya_kumar — Thu, 03 Jul 2014 06:57:01 GMT

Hi Ram,

This is the expression which i used

=aggr(if(rank(Volume, Name) <=10, Name), 'others')

It did not work.

tresB — Thu, 03 Jul 2014 07:01:19 GMT

Try like:

=aggr(if(rank(Sum(Volume)) <=10, Name), 'others')

udaya_kumar — Thu, 03 Jul 2014 07:11:44 GMT

Hi,

I tried that expression, but it is not working.

It is not showing anything.

Please find my file attached.

tresB — Thu, 03 Jul 2014 07:17:03 GMT

Corrected!

=aggr(if(rank(Sum(Volume)) <=10, Name, 'others'), Name) //working

muniyandi — Thu, 03 Jul 2014 07:19:35 GMT

Hi Uday,

use this expression in calculated dimension. if(Aggr(rank(Sum(Volume)),Name)<=10,Name,'Others')

Kindly refer my attachment file.