topic Re: Conditional Sum in QlikView

Conditional Sum

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

I am trying to find the % of the filed [Open Balance] to the Total([Open Balance]).

The issue is that I have to find this percentage in the [SheetName] I have picked.

For Example:

Total Open Balance is $10,000,000.

I select only one [SheetName]

Open Balance in the [SheetName] I have selected is $1,500,000.

After that I select a Client. I am looking for my text box to show:

The sum of that clients [Open Balance] / The Total [Open Balance] for that [SheetName].

Any help is much appreciated. And if further clarification is needed please let me know.

My original thoughts were using some sort of variable.

Thanks!!!

-Jim

sunny_talwar — Wed, 06 Jul 2016 19:37:25 GMT

May be like this:

Sum([Open Balance])/Sum({<SheetName>} [Open Balance])

Where you make selection in SheetName

Sum([Open Balance])/Sum({1} [Open Balance])

vikramv — Wed, 06 Jul 2016 19:55:05 GMT

something like this....

Sum([Open Balance])/Sum(Total <SheetName> [Open Balance])