topic Re: Formula Sum gives unexpected behavior in QlikView

Formula Sum gives unexpected behavior

alwinsch — Mon, 21 Jan 2013 15:36:04 GMT

Hi all,

I have the following formula in a chart.

sum (if(Load_month= 2,({<[Status AO] ={'In Behandeling'} + {'Gerealiseerd'}>}PrAO)))

But it gives some strange values, or better it gives me an error.

Please any help.

I want to show the sum of PrAO for one particular Load_month

and the Status should be one of the following: 'In Behandeling' + 'Gerealiseerd'

can anybody rewrite the formula?

Thanks,

Kind regards.

Alwin

alwinsch — Mon, 21 Jan 2013 15:39:17 GMT

Nevermind... solved the problem myself.

sum

({<[Status AO] ={'In Behandeling'} + {'Gerealiseerd'}>}if(Load_month=2, PrAuto,0))

Thanks.

Nicole-Smith — Mon, 21 Jan 2013 15:39:22 GMT

Try sum ({<Load_month = {2}, [Status AO] ={'In Behandeling'} + {'Gerealiseerd'}>}PrAO)