Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
viswas1986
Contributor III
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

4 Replies
sunny_talwar

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
Contributor III
Contributor III
Author

@Sunny T,

Thank you Sunny, the first one is working great.

sunny_talwar

Awesome

Luc-HvA
Contributor
Contributor

Hello Sunny_talwar,

You are a HERO!