topic Re: Restrict calculation in an expression in QlikView

Restrict calculation in an expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I just wanted to know if there was any way I could restrict my calculation over a specific dimension. At the time, my calculation is the percentage considering all the elements of the dimension, but I would like to restrict them only to the individual percentage of each element.

For example:

I'm using 2 dimensions, but the calculation should be restricted only to individual elements of the dimension 'org'.

That's my calculation:

And I got this:

the calculation of the percentage is considering all the elements of the dimension, but I would like to restrict them individually.

Like this:

THANK YOU!!

Re: Restrict calculation in an expression

sunny_talwar — Tue, 03 May 2016 14:19:36 GMT

Try this expression:

Sum(perc)/Sum(TOTAL <Org> perc)

Re: Restrict calculation in an expression

Anonymous — Tue, 03 May 2016 17:30:40 GMT

Very Good, Sunny, but when I click on the legend to perform a filter, it brings me to filter result all 100%. I would click it and bring me the exact percentage, as it appears before filtering. It's possible?

BEFORE

AFTER

Re: Restrict calculation in an expression

sunny_talwar — Tue, 03 May 2016 18:04:26 GMT

May be this:

Sum(perc)/Sum(TOTAL <Org> {<Status>}perc)

Sum(perc)/Sum(TOTAL <Org> {1} perc)

Re: Restrict calculation in an expression

Anonymous — Tue, 03 May 2016 18:27:02 GMT

Thank you!!!

You Always help me!

Re: Restrict calculation in an expression

sunny_talwar — Tue, 03 May 2016 18:30:22 GMT

Just so you know:

Expression 1) Sum(perc)/Sum(TOTAL <Org> {<Status>}perc)

The denominator will only remain the same based on selection in Status field. Other field selections will still filter the expression

Expression 2) Sum(perc)/Sum(TOTAL <Org> {1} perc)

The denominator will stay the same regardless of any selection you might make.