Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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