4 Replies Latest reply: Jul 4, 2017 4:43 AM by Andy Weir RSS

    IF Statement to give Output

    Erwin Vullers

      Hi there,

       

      I'm new to Qlik Sense, I normaly use POWER BI but our company is implementing Qlik Sense as the new standard.

       

      I'm trying the following,  have a colomn with a date in it.

      I want a new colomn with 3 values based on this date field.

       

      If the date field is empty it should give a  "-"

      If the date field is today or before it should say "over due"

      If the date field is after today it should say "OK"

       

      how do I do this is Qlik Sense?

       

      the power BI command for it is this :

       

      Follow up - Status = IF('Topdesk Data'[Date (Follow up)] = BLANK(); "-";IF('Topdesk Data'[Date (Follow up)] <= (NOW());"Over Due";"OK"))

       

      THX for you help.