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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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