topic Re: How to display values on data points after selection on a chart in QlikView

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

Tue, 18 Oct 2016 14:02:05 GMT

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

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

Gysbert_Wassenaar — Tue, 18 Oct 2016 14:26:07 GMT

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)

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

avinashelite — Tue, 18 Oct 2016 14:30:59 GMT

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)

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

effinty2112 — Tue, 18 Oct 2016 14:38:37 GMT

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

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

Tue, 18 Oct 2016 15:05:58 GMT

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?

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

Tue, 18 Oct 2016 15:25:10 GMT

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?

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

Gysbert_Wassenaar — Tue, 18 Oct 2016 15:38:14 GMT

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

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

Tue, 18 Oct 2016 15:45:41 GMT

oh sorry..

I may sound dumb but why <=3 ??