Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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.