Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

ranajit81
New 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
Valued Contributor II

Re: Using greater than as a variable from inputbox inside set analysis

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
MVP & Luminary
MVP & Luminary

Re: Using greater than as a variable from inputbox inside set analysis

See attached example.


talk is cheap, supply exceeds demand
balkumarchandel
Valued Contributor II

Re: Using greater than as a variable from inputbox inside set analysis

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
New Contributor III

Re: Using greater than as a variable from inputbox inside set analysis

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