Measure is not working in Qlik Sense Pie Chart

[bvssudhakar]

Hi,

I have created Pie chart with dimension named as valueList('Programme Cost','Management Cost')

and the measure is 

if(valueList('Programme Cost','Management Cost')='Programme Cost',
Sum(aggr(Sum({$<CostType = {'Programme'}>} distinct BudgetAmount),ActivityId,ActivityCode,BudgetLine,BudgetAmount,RUNO)),
Sum(aggr(Sum({$<CostType = {'Management'}>} distinct BudgetAmount),ActivityId,ActivityCode,BudgetLine,BudgetAmount,RUNO)))

This measure is showing Only 1st parameter Value. It is not giving 2nd parameter value to compare in pie chart.

If I create individually two KPI's With these two measures  values are Showing. But in pie chart it is not working

I am not understanding what I missed. Can you guys please help me out from this

Thanks & Regards,

B V S Sudhakar

[Kushal_Chawda]

@bvssudhakar  try below

=pick(match(valueList('Programme Cost','Management Cost'),'Programme Cost','Management Cost'),
Sum(aggr(Sum({$<CostType = {'Programme'}>} distinct BudgetAmount),ActivityId,ActivityCode,BudgetLine,BudgetAmount,RUNO)),
Sum(aggr(Sum({$<CostType = {'Management'}>} distinct BudgetAmount),ActivityId,ActivityCode,BudgetLine,BudgetAmount,RUNO)))

[bvssudhakar]

Hi @Kushal_Chawda ,

I tried your measure but no luck. If remove aggr thing it is showing values which are not correct

Thank you in advance

[Chanty4u]

can you try this

=pick(match(valueList('Programme Cost','Management Cost'),'Programme Cost','Management Cost'),
aggr(Sum({$<CostType = {'Programme'}>} distinct BudgetAmount),ActivityId,ActivityCode,BudgetLine,BudgetAmount,RUNO)),
aggr(Sum({$<CostType = {'Management'}>} distinct BudgetAmount),ActivityId,ActivityCode,BudgetLine,BudgetAmount,RUNO)