topic Re: Multiple error messages for 1 calculation condition in QlikView

Multiple error messages for 1 calculation condition

CanOls — Sat, 16 Nov 2024 20:34:13 GMT

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!

Re: Multiple error messages for 1 calculation condition

Vegar — Thu, 27 Jun 2019 11:46:25 GMT

What if you do this in your message expression?

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

-Vegar

Re: Multiple error messages for 1 calculation condition

CanOls — Thu, 27 Jun 2019 12:27:23 GMT

That did the trick!

Thank you for the help.