Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ranajit81
Contributor III
Contributor III

Using greater than as a variable from inputbox inside set analysis

The title might be confusing so I will clarify. I have 2 inputboxes. The first inputbox contains (>, =, ) . The second inputbox will accept number of Days.

Example: User picks '>=' from a dropdown select and 5 as number of days. It will store both values as variables. Instead of using '>=' as in the formula below, I want to put the '>=' in the stored variable in its place instead.

=sum({$<

[Year] = {2012},

[Days between shipping] = {">=$(=$(vDays))"}

>}[Revenue])

I tried various ways so posting for help was my last option. Thank you for your help.

1 Solution

Accepted Solutions
balkumarchandel
Specialist II
Specialist II

I will suggest don't use inputbox for operator selection give user a list box for that just load inline

all operator which you want to give as option so that user can maintain integrity as well (avoid typo)

then create a variable with

vOperator=GetFieldSelections(Operator)

then use variable in your set analysis

$(vOperator)

PS: Operator is column name

Thanks

BKC

View solution in original post

3 Replies
Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand
balkumarchandel
Specialist II
Specialist II

I will suggest don't use inputbox for operator selection give user a list box for that just load inline

all operator which you want to give as option so that user can maintain integrity as well (avoid typo)

then create a variable with

vOperator=GetFieldSelections(Operator)

then use variable in your set analysis

$(vOperator)

PS: Operator is column name

Thanks

BKC

View solution in original post

ranajit81
Contributor III
Contributor III
Author

Acutally, I set mine up as dropdown select with predefined values.