Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to add list values in Input box dropdown?

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

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

4 Replies
Not applicable
Author

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

];

Not applicable
Author

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.

Not applicable
Author

Thanks Rebeccad. It works perfectly.

Mounika4
Contributor III
Contributor III

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