Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've data in the column as below:
A
1
2
3
4
5
6
7
.
100
- I've created a input box with variable vLastA and the list values as ALL;1;2;5;10;20;30;50;90
- I had taken another global variables as vA,vAMin,
the data of the variable is: vA = Max(A) i.e. 100 and vAMin =$(vA)-$(vLastA ) (i.e. if i select 2 in the input box i'll get the value as 98)
Task:
I want to put validation for the inputbox.
Here i'm consider medium value as i.e vMedium= 20
For eg:
if i select 90 in the input box the value of vAMin is 10. If the value of vAMin is less than vMedium(i.e 20) then i want see error message.
Validation rules:
1. If it is ALL fine.
2. if the varaible is empty show error message.
3. If the value of vAMin is less than vMedium then i want see error message.
Please, look at the attached qlikview which shows how to include a constraint and error message.
Karl