topic Re: Use dimension total in expression in QlikView

Use dimension total in expression

Wed, 30 Mar 2016 13:05:03 GMT

I need to calculate a weighted average in a pivot table for each collapsed dimension value. Something like this:

In order to do this I will need an expression that looks like this:

Interest rate of individual loan / sum of all loan outstanding balances in category

Is it possible to do this in an expression or will I need to do it in the load script?

Thanks

sunny_talwar — Wed, 30 Mar 2016 13:06:47 GMT

I think it should be possible. What is the expected output based on your provided sample?

mohamed_ahid — Wed, 30 Mar 2016 13:11:37 GMT

try to do it with an Aggr(Interest rate of individual loan / sum of all loan outstanding balances in category ,Category) function it will works .

the best way is to do it while loading of corse .