How to display values on data points after selection on a chart

[#1]

Hi all

I want to display values on pie chart, but as there are too many dimensions on the pie chart. data values are overlapping

like the image below

How to display values on data points in a pie chart, on selecting  a dimension value from the legend in that pie chart or after the selection of values in the dashboard.

Thanks

[Gysbert_Wassenaar · Accepted solution]

Use a bar chart with horizontal bars instead and use Dimension Limits to show the top 5 and group the rest as Other.

If you really want to use the dysfunctional pie chart then click on the + in front of the expression, select Show Value and enter an expression like if(GetSelectedCount(MyDimension)>0 and GetSelectedCount(MyDimension)<=3,1,0)

[avinashelite]

Try like this

Expression 1: without value on data pointchecked

enable conditional like if(getselectedcount(dimesnion)=0,1,0)

Expression 2: with value on data point checked

if(getselectedcount(dimesnion)>0 ,1,0)

[effinty2112]

Hi,

          This is a different approach taken from Stephen Redmond's Qlikview for Developers Cookbook.

Dual(

  DimensionName& '-' &

  Num(sum(Measure)) &

  Repeat(chr(13)&chr(10), rank(Sum(Measure))-6),

  sum(Measure)

)

Substitute your dimension name and measure in to the above and use it as your expression. This will space out the labels and may give you what you need.

Good luck

Andrew

[#5]

Hi Avinash,

when i do this, pie chart disappears when i select a dimension on pie chart

you want me to write the expression on in the layout tab--> show--> conditional right?

[#6]

HI gysbert

Thank youI have got the problem solved.. with the first expression.. But, I didnt understand the second expression you have given, why did you took <=3?

could you explain me that?

[Gysbert_Wassenaar]

There's only one expression. Everything after 'like ' is the expression.

[#8]

oh sorry..

I may sound dumb but why <=3  ??