topic Using greater than as a variable from inputbox inside set analysis in QlikView

Using greater than as a variable from inputbox inside set analysis

Anonymous — Mon, 08 Jun 2015 14:28:56 GMT

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.

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

Gysbert_Wassenaar — Mon, 08 Jun 2015 14:42:28 GMT

See attached example.

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

Anonymous — Mon, 08 Jun 2015 14:44:40 GMT

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

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

Anonymous — Tue, 09 Jun 2015 17:03:28 GMT

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