Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
User12321
Contributor III
Contributor III

Percentage based on dimension

Hi,

I have a pivot table with dimensions Category and Item. I want to create a percentage column defined as the item amount divided by the item category amount. 

Any suggestion on how to create the percentage column please. Thank you.

Labels (1)
1 Solution

Accepted Solutions
rubenmarin

Hi, you can use the TOTAL qualifier to tell the expression to ignore dimensions, and between <> tell wich dimension it has to use, so this can be:

Sum(Amount)/Sum(TOTAL <CategoryFieldName> Amount)

View solution in original post

1 Reply
rubenmarin

Hi, you can use the TOTAL qualifier to tell the expression to ignore dimensions, and between <> tell wich dimension it has to use, so this can be:

Sum(Amount)/Sum(TOTAL <CategoryFieldName> Amount)