Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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
MVP
MVP

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!