Dynamically Change Variable Values in Expression

[#1]

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,

[marcus_sommer · Accepted solution]

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

t:

Load * Inline [

value

5

50

80

90

];

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

[#3]

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

[jagan]

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

10

20

30

40

50

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.