topic Re: Or statement in variable in QlikView

Or statement in variable

Fri, 05 Apr 2013 09:21:16 GMT

Hi, I want to make a variable with an or-statement.

Need some help?

=sum({<Groep1={'M10' } or Groep1={'M20'}>}MISTotaal)

alexandros17 — Fri, 05 Apr 2013 09:22:07 GMT

=sum({<Groep1={'M10' ,'M20'}>}MISTotaal)

hope it helps

Fri, 05 Apr 2013 09:38:37 GMT

But now, I want to use this variable in my chart.
When I just put vVerkoop (title of the variable =sum({<Groep1={'M10' ,'M20'}>}MISTotaal) )

in the expression, I got error: allocated memory exceeded

Is it possible to just mention the variable, or should I paste =sum({<Groep1={'M10' ,'M20'}>}MISTotaal) in the expression?

alexandros17 — Fri, 05 Apr 2013 09:43:28 GMT

vVerkoop sum({<Groep1={'M10' ,'M20'}>}MISTotaal) )

IN the expression refer to

$(vVerkoop)