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.
Can any one suggest how to add Percentage in Sub Total Percentage in Qlik sense Pivot Table.
I think the best you can do (without extension and without modifying the script) is this:
I created only some values to test (2 dimensions with only quantity)
Expression for % quantity is:
View solution in original post
Just add another measure: %
and try this expression:
where function: is the function you want to use, example (sum, count...) and field: is your Measure field
Thank you for your Reply.
I will works as per your logic.
I want to show in Sub Total.
It will be sown as another column.
sub total is displayed when your dimension is not expanded, right ?
Its fully Expanded
can you take a screen shot of your pivot table expanded and attach it here please ?
Maybe he's refering to sthing like this:
sum(Measure) / sum( total <Dim> Measure)
I'll let you handle this youssefbelloum
as soon as I see the expected output
sum(total <UrRegionDim> YourMeasure) / sum(total YourMeasure)