topic Re: Nested If statement with set analysis not working in QlikView

Nested If statement with set analysis not working

helen_pip — Tue, 18 Feb 2014 15:27:00 GMT

Hello

I have written the following statement and although the 2 elements work when seperated, I cannot seem to get it to work together

Could someone kindly cast an eye over my statement and let me know what I am doing wrong

=Count(IF(v_Start_Date_ED = v_Min_Date_ED_Calender and v_End_Date_ED = v_Max_Date_ED_Calender1,ID,

COUNT(IF(FactDate>=$(v_Start_Date_ED) and FactDate <= $(v_End_Date_ED), ID))))

Kind Regards

Helen

Re: Nested If statement with set analysis not working

alexandros17 — Tue, 18 Feb 2014 15:33:17 GMT

TRy to delete the second nested count

Count(IF(v_Start_Date_ED = v_Min_Date_ED_Calender and v_End_Date_ED = v_Max_Date_ED_Calender1,ID,

(IF(FactDate>=$(v_Start_Date_ED) and FactDate <= $(v_End_Date_ED), ID))))

Re: Nested If statement with set analysis not working

helen_pip — Tue, 18 Feb 2014 15:38:15 GMT

Hello Alessandro

Hours....I mean hours I have been staring at that statement.....Minutes to resolve...Thank you so much

This works for me now

Thanks

Helen

Re: Nested If statement with set analysis not working

alexandros17 — Tue, 18 Feb 2014 15:50:32 GMT

I'm really happy to have helped you!

Bye

Alexandros

Re: Nested If statement with set analysis not working

helen_pip — Wed, 19 Feb 2014 08:48:25 GMT

Hello Alexandros

As a victim of your own success, I was wondering if you could kindly help me with the following statement

I have tried applyting the same logic as you helped me wtih before, but this time I am using the Fractile equations and trying to express the answer as a time

Again, both statements work well individually, it is when I have to put the tow statements together, it doesn't work with my master calender

The problem seems to be around the comma between statement 1 and statement 2

=Time(Fractile(If(FactDate>=$(v_Start_Date_ED) and FactDate <=$(v_End_Date_ED), [Total Wait]),0.95)/1440, 'HH:MM',

(IF(FactDate>=$(v_Start_Date_ED) and FactDate <=$(v_End_Date_ED),[Total Wait],0.95)/1440))

Any help or advice would be greatly appreciated

Kind Regards

Helen

Re: Nested If statement with set analysis not working

alexandros17 — Wed, 19 Feb 2014 09:05:36 GMT

The problem is related to unbalanced parenthesis, always start from the inner part:

If(cond1, v1, if(cond2, v2, v3))

then add your function:

Fractile(If(cond1, v1, if(cond2, v2, v3)))

then add your formatting:

Time(Fractile(If(cond1, v1, if(cond2, v2, v3))),'format')

hope it helps

Re: Nested If statement with set analysis not working

helen_pip — Wed, 19 Feb 2014 09:14:31 GMT

Thank you for this

Applying this logic has really help me and I shall continue to apply this logic

Thanks again....I think I am alright now

Thanks

Helen