Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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