Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
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

Re: Pivot table - Getting ratio based on partial total

See the attached.

3 Replies

Re: Pivot table - Getting ratio based on partial total

See the attached.

Not applicable

Re: Pivot table - Getting ratio based on partial total


Nicole- thanks a lot!

Re: Pivot table - Getting ratio based on partial total

I'm glad it worked

Community Browser