This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a pivot table with dimensions MonthYear, Category and Item. I want to create a percentage column defined as the item amount divided by the item category amount.
Example: Amount for Item Apple / Amount for Fruits Category will give me 33.33% in the percentage column.
I tried the below expression but it is not working.
Any suggestion on how to create the percentage column please. Thank you.
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
Hi @rubenmarin ,
Your solution works perfectly well. Thank you very much!