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

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

Store listbox multiple selected value into variables or array

I have an issue where i want to store selected value in the listbox into variable and use the stored value for analysis,

do i need to use the objectID or just use the listbox title itself?

i need to use it for the marker color so i can separate the marker color for each value.

Regards,

Thank You

1 Reply
JonnyPoole
Former Employee
Former Employee

You could use the concat() function to store an array.

If your listbox field was [FieldName] then your variable definition would be:

concat( distinct [FieldName], ' ;' )

It will create a long string delimitted by the 2nd arguement in this example a ';' . 

You could check the string for the presence of a specific string using substringcount(). If the variable was vSelectedValues this would be a sample usage. Use $ sign expansion to invoke the variable like this:

IE:   if( substring( $(vSelectedValues) , 'Sample Value')  > 0 ,  red(), blue())