Discussion Board for collaboration on QlikView Scripting.
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?
I think it should be possible. What is the expected output based on your provided sample?
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 .