Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ismaelmanager
New Contributor

Dividing a dimension value by another dimension value

I want to get the value of the dimension Category='a' and divide for the current dimension category value

 

idcategoryvalue%
1a25
2b25
3c40
4d15   1,67 "=category a / category d"
3 Replies
MVP
MVP

Re: Dividing a dimension value by another dimension value

Sum({<category={'a'}>} Total value)/Sum(value) should be enough

ismaelmanager
New Contributor

Re: Dividing a dimension value by another dimension value

Thanks, Clever.

oknotsen
Honored Contributor III

Re: Dividing a dimension value by another dimension value

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!