Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
aadil_machiwala
Contributor
Contributor

Calculate % based on sub-totals

Hi Gurus, 

I need your help to understand how I can calculate % share based on sub-total value.

I am currently using AGGR(SUM(QUANTITY),FULL_OR_EMPTY) and by doing so I am able to get sub-total for 1 row item instead of all the row items under group "FULL_OR_EMPTY" 

Your help to extend this sub-total to all the row items is needed. 

Thanks & regards,

Aadil

Labels (3)
1 Reply
aadil_machiwala
Contributor
Contributor
Author

Hi, 

I was able to resolve this by following code SUM(TOTAL <FULL_OR_EMPTY>QUANTITY)

Thanks & regards,

Aadil