Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Tags (2)
1 Reply
Employee
Employee

Re: Store listbox multiple selected value into variables or array

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())

Community Browser