This content has been marked as final. Show 3 replies
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.
Happy New Year to all