Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rakeshkumar1890
Creator
Creator

Pie Chart Label - Dimension with calculation

Hi Folks,

Need your help, I am trying to visualize pie chart with dimension and calculative number. Below is my code but not getting the value and percentage of total value.

CommodityGroup  &' : '&

aggr(sum(aggr(only({<Reason={'SHIPPED'},Pcdd_Pull ={'pull-in'}>}FusionPcdd_Pull_Count),FusionPcdd_Pull_Count)),CommodityGroup)

&'; '&
aggr(num(sum(aggr(only({<Reason={'SHIPPED'},Pcdd_Pull ={'pull-in'}>}FusionPcdd_Pull_Count),ComponentPartNumber,SapSoli))
/
sum(Total Aggr(sum(aggr(only({<Reason={'SHIPPED'},Pcdd_Pull ={'pull-in'}>}FusionPcdd_Pull_Count),ComponentPartNumber,SapSoli)),FusionPcdd_Pull_Count)),'#,##0%'),CommodityGroup)

Can team please help me to resolve the calculation.

 

Kind Regards

Rakesh Kumar

0 Replies