Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Where clause in Qlik Sense Script

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?

View solution in original post

Highlighted
krithikarees
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.