3 Replies Latest reply: Dec 30, 2016 8:52 PM by Sunny Talwar RSS

    OR Function

    Viswanathan Srinivasan

      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