Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
CanOls
Contributor III
Contributor III

Multiple error messages for 1 calculation condition

Hi, Im new to QlikView and could use some help.

I'm using a calculation condition to ensure that users select 1 University from a list box. But it has to be just 1. 

=GetSelectedCount(University)=1

Then I add a Custom Error message if the count isn't 1. But, I'd like to add 2 messages that depends on the users selection.

If the user has made 0 selections I'd like to display the error message "Select 1 university",  and if the user has made 2 or more selections, I'd like to display "Select only 1 university".

Any help is appreciated!

 

1 Solution

Accepted Solutions
Vegar
MVP
MVP

What if you do this in your message expression?

=IF(getSelectedCount(University)=0,
   'Select one university',
   'Select only one university')

 

-Vegar

View solution in original post

2 Replies
Vegar
MVP
MVP

What if you do this in your message expression?

=IF(getSelectedCount(University)=0,
   'Select one university',
   'Select only one university')

 

-Vegar

CanOls
Contributor III
Contributor III
Author

That did the trick! 

Thank you for the help.