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

percentage for due date intervals in single expression

Hello community,

I have a bunch of due date intervals like: <5d ; 5d><=30d and so on.

Those are strings in a field called AgeGroup with a corresponding ID called AgeBucket.

I built a pivot table with the AgeGroup as a dimension and a sum expression using a variable.

SUM($(vAmount))

I arranged the AgeGroup horizontally to show each due date interval in its own column.

This was fine until I also wanted to add the calculated percentage for each due date interval based on the total.

Can I do that in a single expression so that the individual intervals add up to 100% ?

Or do I have to use multiple AgeGroup expressions like this:

sum({$<[Age Bucket]={2},[Age Group]=>} $(vAmount)) /

sum({$<[Age Group]=>} $(vAmount))

Thank you,

Thorsten

1 Solution

Accepted Solutions
whiteline
Master II
Master II

Hi.

There is total modifier that can reject dimensions in calculation.

sum(total $(vAmount)) gives you the total amount of all AgeGroups.

sum($(vAmount)) /sum(total $(vAmount)) gives you the percentage.

Set analysis works alike user selections instead.

View solution in original post

2 Replies
Not applicable
Author

Share your QVW. its not clear

whiteline
Master II
Master II

Hi.

There is total modifier that can reject dimensions in calculation.

sum(total $(vAmount)) gives you the total amount of all AgeGroups.

sum($(vAmount)) /sum(total $(vAmount)) gives you the percentage.

Set analysis works alike user selections instead.