topic Dynamically Change Variable Values in Expression in QlikView

Dynamically Change Variable Values in Expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a vSL variable name with 80 as value and use this variable in this expressions, =20+vSL. Thus, the result would be 100. How can I create a list box with different values, so when I check one of these value then the result will change?

Please let me know If you think there is a better approach. All inputs are greatly appreciated. Thank you.

Best,

Re: Dynamically Change Variable Values in Expression

marcus_sommer — Thu, 14 Apr 2016 15:01:48 GMT

For this you would need to create a small table maybe something like this:

Load * Inline [

value

];

and then using this field within a listbox with (option one selected only) and in your expression something 20 + getfieldselection(value).

Where you could use a list also create for a variable within the tab restrictions from the inputbox (bottom right).

- Marcus

Re: Dynamically Change Variable Values in Expression

Thu, 14 Apr 2016 15:22:09 GMT

Exactly what I need! Thank you very much Marcus!!

Re: Dynamically Change Variable Values in Expression

jagan — Thu, 14 Apr 2016 15:23:43 GMT

Hi,

Create and Inline table or an excel file with the required number and load it in qlikview and provide this as a filter. Now you simply use

Numbers:

LOAD

INLINE [

NewFieldName

60];

=20 + Sum(NewFieldName)

Or the best method is provide an input box and assign this variable to the input box, and get input from user and use this variable in your expression.

=20 + variableName

Hope this helps you.

Regards,

Jagan.