Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
What if you do this in your message expression?
=IF(getSelectedCount(University)=0,
'Select one university',
'Select only one university')
-Vegar
What if you do this in your message expression?
=IF(getSelectedCount(University)=0,
'Select one university',
'Select only one university')
-Vegar
That did the trick!
Thank you for the help.