topic Re: How to keep my variable fixed? in QlikView

How to keep my variable fixed?

Tue, 24 Jul 2012 14:04:16 GMT

All to you all,

Once more I need your advice…

I’m calculating an average value using this:

sum(aggr(sum(ac+dc),A))/sum(aggr(sum(ac+dc+dnc+anc),A))

this is put into a variable.

Now when is start making my selections, this value, obviously, changes and I like to make it stick with my original calculation prior my selection.

I’m not calculating this in the load script.

Set analysis maybe? Or any other simple way?

Thanks

Tue, 24 Jul 2012 14:25:34 GMT

Hi,

If you don't want your calculation to depend on selections (if this is what you mean by 'original calculation') try this:

sum({1}aggr(sum({1}ac+dc),A))/sum({1}aggr(sum({1}ac+dc+dnc+anc),A))

Tue, 24 Jul 2012 14:37:38 GMT

does the trick, thanks a lot

CELAMBARASAN — Tue, 24 Jul 2012 14:41:07 GMT

Aggr only does on the possible values of the given dimension.

Try this I think it will also be same as yours(Check it.I hope so )

(Sum({1}ac)+Sum({1}dc))/(Sum({1}ac)+Sum({1}dc)+Sum({1}dnc)+Sum({1}anc))