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: 
Not applicable

Input box custom

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.

1 Reply
pover
Partner - Master
Partner - Master

Please, look at the attached qlikview which shows how to include a constraint and error message.

Karl