Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY

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.