Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!