Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You can add an "else" portion to your "if" statement:
=IF (GetSelectedCount([Program Acronym]) = 1, [Fund Revision Date], 'Please select one program')
You can add an "else" portion to your "if" statement:
=IF (GetSelectedCount([Program Acronym]) = 1, [Fund Revision Date], 'Please select one program')
Thank you!