topic Re: Error in SUM expression in QlikView

Error in SUM expression

alwinsch — Fri, 07 Mar 2014 10:37:32 GMT

Hi all,

I had an expression which worked out fine.

Sum({<Status = {'Gerealiseerd'}>}CommAuto)

but i want to add a new condition
.
Sum(Max(Load_month) , {<Status = {'Gerealiseerd'}>}CommAuto)

But it gives me an error.

Every month we load our data in a qvd file, with a variable Load_month,

So in my expression i want to make a sum with only MAX(Load_month)

Please can anyone give me a solution?

kind regards,

Alwin

alexandros17 — Fri, 07 Mar 2014 10:44:10 GMT

Sum({$ <Status = {'Gerealiseerd'}, Month={'$(=Max(Load_month))'}>}CommAuto)

please verify that your field is Month and that its format is the same for Max(Load_Month)

hope it helps

alwinsch — Fri, 07 Mar 2014 10:46:52 GMT

Thanks, it helped

but i do not have to use the first $ sign in your expression.