Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone help me writing an expression for adding list values in input box dropdown?
I want following values in a input box dropdown?
5
8
10
12
15
How can I write it in an expression?
Thanks,
TA
To add a drop-down selection to an input box, go to Input Box Properties > Constraints > Value List > Select 'Predefined Values in Drop-down', > Deselect 'Enable Edit Expression Dialog' > Select 'Listed Value' > Enter values separated by a semi-colon. I also like to hide the equal sign. See attached.
I do not think you can do this with an expression, however you can add a inline load to the script to create a field that contains these values:
LOAD * INLINE [
List_Value
5
8
10
12
15
];
To add a drop-down selection to an input box, go to Input Box Properties > Constraints > Value List > Select 'Predefined Values in Drop-down', > Deselect 'Enable Edit Expression Dialog' > Select 'Listed Value' > Enter values separated by a semi-colon. I also like to hide the equal sign. See attached.
Thanks Rebeccad. It works perfectly.
Hi
i am doing migration from qlikview to qlikcloud. so in qlikview they used Input Box Properties > Constraints > Value List > Select 'Predefined Values in Drop-down', >Select 'Listed Value' > Enter values separated by a semi-colon. in listed value column they given some condition ...
in Qlik Cloud ...we have a variable input chart but we dont have option to add that listed values condition
If any idea pls rply here ..how to implement in Qlikcloud
Thank you