Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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!

 

Labels (1)
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.