Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
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
Exactly what I need! Thank you very much Marcus!!
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.