2 Replies Latest reply: Jul 2, 2018 5:46 PM by Lea Cueva RSS

    Add second condition to expression

    Lea Cueva



      I am using the following expression in Qlik Sense, and it's working great. 

      =IF (GetSelectedCount([Program Acronym]) = 1, [Fund Revision Date])

      What it does: if a program acronym is selected, then the fund revision date appears.


      I want to add a second condition, so that if a program acronym is not selected, the following text appears "Please select one program".


      How do I modify my expression to add in the second condition?