Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

leacueva
New Contributor II

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

Re: Add second condition to expression

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

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

2 Replies

Re: Add second condition to expression

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

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

leacueva
New Contributor II

Re: Add second condition to expression

Thank you!

Community Browser