Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More

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.