Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
viswas1986
New Contributor III

OR Function

Hi friends,

I am using the below formula in Qliksense to make a 'if' condition. No error is found but it is not working.


if("Category"=CAT 1' or 'CAT 2' or 'CAT 3' and isnull("CAT 0"),'Date not updated','Date is updated'),


Here i am using a excel file in that   "Category" and "CAT 0" is Header. In "Category", if CAT 1 or CAT 2 or CAT 3 is specified then Date of the Updation should be specified in "CAT 0". This is my criteria. Please help me on this.


Thank you


Happy New Year to all

3 Replies

Re: OR Function

Try this instead

If(Match("Category", CAT 1', 'CAT 2', 'CAT 3') and IsNull("CAT 0"), 'Date not updated', 'Date is updated')

or

If(("Category" = CAT 1' or "Category" = 'CAT 2' or "Category" = 'CAT 3') and IsNull("CAT 0"), 'Date not updated', 'Date is updated')

viswas1986
New Contributor III

Re: OR Function

@Sunny T,

Thank you Sunny, the first one is working great.

Re: OR Function

Awesome