topic Re: Help with if expression in QlikView

Help with if expression

Mon, 18 Jan 2016 13:36:57 GMT

My expression:

IF(Min(MONTHYEAR) > Min(MONTHYEAR2) and isnull(FIELD1),FIELD1B,if(Min(MONTHYEAR) > Min(MONTHYEAR2) and len(FIELD1)>0,FIELD1)) as Value

I need this:

1.-if(Min(MONTHYEAR) > Min(MONTHYEAR2) and isnull(FIELD1) output FIELD1B

2.-if(Min(MONTHYEAR) > Min(MONTHYEAR2) and isnotnull(FIELD1) output FIELD1

What I am doing wrong? Thanks!

Re: Help with if expression

Gysbert_Wassenaar — Mon, 18 Jan 2016 18:02:00 GMT

Looks ok to me. If you're using this expression in a load script then make sure to add every field that is not used in an aggregation function, like min(), to the Group By clause of that load.

Re: Help with if expression

sunny_talwar — Mon, 18 Jan 2016 18:02:43 GMT

May be this:

If(Min(MONTHYEAR) > Min(MONTHYEAR2), If(Len(Trim(FIELD1)) = 0, FIELD1B, FIELD1)) as Value

But note that you will get null when Min(MONTHYEAR) <= Min(MONTHYEAR2). If that's what you want then above should work for the two conditions you have give above.

Re: Help with if expression

Tue, 19 Jan 2016 08:46:25 GMT

Hello!

I put it all the information here: Problem with if expression

thanks!