Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More

Re: Where clause in Qlik Sense Script

How about when you use just this


[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?

View solution in original post

New Contributor III

Re: Where clause in Qlik Sense Script

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.