Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am noticing that only the first where clause condition is being executed and the rest is ignored. Is there a reason why Qlik Sense does this? Or is there anything wrong with my script?
Thanks in advance
Load
..
...
......
...........
From (lib://qvdstage1/abcd/accc.QVD)(qvd)
Where
[Controlling Area_CO_AREA]= 'VMS1' or '#' and
[Chart of accounts_CHRT_ACCTS] = 'VSM1' and
[Fiscal Year Variant_FISCVARNT] = 'V8' and
([Clearing Date]='' or num(Today(2))- num([Clearing Date]) < 90)
;
How about when you use just this
Where
[Chart of accounts_CHRT_ACCTS] = 'VSM1' and
[Fiscal Year Variant_FISCVARNT] = 'V8' and
([Clearing Date]='' or num(Today(2))- num([Clearing Date]) < 90)
What do you get?
it is interesting that when I ignore the first line it does not change anything. I did the same with each line after controlling area and did not see any changes.
Thank you. Appreciate your help.