topic Nested If Statement Validation in QlikView

Nested If Statement Validation

Wed, 24 Jun 2015 12:59:03 GMT

Hello folks,

I have noticed that a case that should be picked up by the 4th line of code in the statement below is actually passing thru to the 5th line.

After spending some time looking at this statement, I am unable to identify where it is going wrong, so am hoping someone could help me trouble shoot my logic, syntax?

( If(Level='Lvl 1' and open_date+30 < Today(), 0,

If(Level='Lvl 1' and open_date+30 >= Today(), NetWorkDays(Today(),open_date+30),

If(Level='Lvl 2' and open_date+60 < Today(), 0,

If(Level='Lvl 2' and open_date+60 >= Today(), NetWorkDays(Today(),open_date+60),

0)))))

Thank-you!

Dan

Re: Nested If Statement Validation

alexandros17 — Wed, 24 Jun 2015 13:11:51 GMT

each date has its numerical rapresentation so you must decide if using a numerical or a date format when you manage data

so:

open_date+30 < Today() shoult be changet to

Num(open_date)+30 < Num(Today())

and so on

Let me know

Re: Nested If Statement Validation

maxgro — Wed, 24 Jun 2015 19:15:13 GMT

what's the case (open_date) you think has problem?