topic IF STATEMENT question month in QlikView

IF STATEMENT question month

jadams123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi experts:

I want to do this:

IF Month is Jan then blah blah,

if Month is Jan + Feb then blah blah.

When I select Jan it works, but when I select Jan + Feb it doesnt work. Whyyyyy??? and how can I make it work. I even used greater than less than and still doesnt work.

=if(MonthNum=1,
(if([Region]='Atlantic',0.0022,
if([Region]='Ontario Sw',-0.0882,
if([Region]='Ontario Ce',-0.0882,
if([Region]='Quebec',0.0913,
if([Region]='West',0.0324,0)))))),
if(Monthnum=1 AND MonthNum=2,
(if([Region]='Atlantic',-0.0069,
if([Region]='Ontario Sw',-0.017526,
if([Region]='Ontario Ce',-0.017526,
if([Region]='Quebec',-0.013556,
if([Region]='West',0.016357,0))))))
,0))

Thanks,

Re: IF STATEMENT question month

Gysbert_Wassenaar — Wed, 27 Mar 2019 17:12:44 GMT

Try one of these options:

=if(MonthNum=1 OR MonthNum=2, ...etc )
=if(Match(MonthNum,'1', '2'), ... etc)

Re: IF STATEMENT question month

rubenmarin — Wed, 27 Mar 2019 17:14:06 GMT

Hi, when asking for a firels, if that field has more than one possible values it will return null(). You need an aggregation funcion that returns one of that many values, ie:
if(Min(MonthNum)=1 AND Max(MonthNum)=2,