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

    Add second condition to expression

    Lea Cueva

      Hello!

       

      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?

       

      Thanks!