Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Use dimension total in expression

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

CategoryWeighted Interest RateOutstanding Balance
14.89$523,467.90
23.55$1,567,896.89
34.37$456,134.45
45.03$2,456,743.84

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

2 Replies

Re: Use dimension total in expression

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

mohamed_ahid
Contributor III

Re: Use dimension total in expression

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 .