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: 
Not applicable

Pivot table - Getting ratio based on partial total


Hi,

For each product I'd like to calculate the ratio of each validity date in terms of quantity. Please see attached file for incorrect approach. what I am looking for is for Product A it's 100% as it only has one validity date, Product B, should be 40%, 20%, 20% and 20% so that they add up to 100%.

I used the samiliar formula for Sum(total <>...) it worked but now I have to use Count. does the syntas differ for Count?? Thanks!

1 Solution

Accepted Solutions
Nicole-Smith

See the attached.

View solution in original post

3 Replies
Nicole-Smith

See the attached.

Not applicable
Author


Nicole- thanks a lot!

Nicole-Smith

I'm glad it worked