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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.