Applying a value from a variable to a dimension

Anonymous — Mon, 04 Jul 2016 16:35:05 GMT

Hi,

I am trying to effect a dimension using 2 variables,

with this formula: ='>=' &vStart_Slider_Selection & '<=' &vEnd_Slider_Selection

my dimension is integer,

but when I apply a value to the variable (using a slider), the variable gets this value:

Despite my effort, the dimension isn't effected:

Thanks!

Re: Applying a value from a variable to a dimension

swuehl — Mon, 04 Jul 2016 16:54:14 GMT

Where exactely are you using your formula? And what exactely do you want to happen?

In a list box, you can try using a field <expression> (selected from the field drop down on general tab) like

=If( [Posting Days] >= vStart_Slider_Selection and [Posting Days] <= vEnd_Slider_Selection, [Posting Days])

This should limit the range of values in your list box.

If you rather like to select the range of values, use a trigger OnInput of your variables and use an Selection - Select in field action with your [Posting Days] as field name and your formula as search string:

='>=' &vStart_Slider_Selection & '<=' &vEnd_Slider_Selection

topic Applying a value from a variable to a dimension in QlikView

Applying a value from a variable to a dimension

Re: Applying a value from a variable to a dimension