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 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.
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