Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
@Sunny T,
Thank you Sunny, the first one is working great.
Awesome
Hello Sunny_talwar,
You are a HERO!