Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ltc
Partner - Creator
Partner - Creator

Add second condition to expression

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!

1 Solution

Accepted Solutions
Nicole-Smith

You can add an "else" portion to your "if" statement:

=IF (GetSelectedCount([Program Acronym]) = 1, [Fund Revision Date], 'Please select one program')

View solution in original post

2 Replies
Nicole-Smith

You can add an "else" portion to your "if" statement:

=IF (GetSelectedCount([Program Acronym]) = 1, [Fund Revision Date], 'Please select one program')

ltc
Partner - Creator
Partner - Creator
Author

Thank you!