Pie Chart Tittle

[_Aankit]

Hello All,

we have query regarding to pie chart in Qlik sense. and the scenario is given below.

I have four Expression in Pie Chart using alternative measure. And we want to show expression tittle in pie chart based on expression selection in exploration menu.

For Example - In Pie chart Dimension is customer classification and measure is CM Sale, LM Sale, MTD Sale, LYCM Sale. If user select CM Sale from Exploration menu then CM Sale as a title/lable visible in pie chart.

How we can achieve this? Please suggest.

Thanks,

Ankit Mishra

[vinieme12]

You will have to change your approach and use variables instead of alternate measures

1) Create a variable, example :  vMeasureList  ( leave the definition empty)

2) Drag a variable input extension from to the sheet, this is what users will use to toggle between the measures;  choose Variable vMeasureList

Display as buttons,  

Values: Choose Dynamic and assign values using below notation

Value~label :    '1~CM Sales|2~LM Sales|3~MTD Sales|4~FYCM Sales'

2) For your Pie chart measure , you have two option

Option 1 :  Using Pick()

in your pie chart add  1 measure as

=Pick(vMeasureList,

Expression for CM Sale,

Expression for LM Sale,

Expression MTD Sale,

Expression for LYCM Sale)

Option 2: Show hide condition with 4 separate measures

CM Sales:  if(vMeasureList=1,1,0)

LM Sales:  if(vMeasureList=2,1,0)

MTD Sales:  if(vMeasureList=3,1,0)

FYCM Sales:  if(vMeasureList=4,1,0)

for Pie Chart Title, just use ='$(vMeasureList)'

[_Aankit]

Hi Vineeth 

This solution will not work in my case. Here you have taken variable input extension. but in my case we have to show  in pie chart without any external object. Please suggest another way.

Thanks,

Ankit Mishra