Store listbox multiple selected value into variables or array

Wed, 10 Sep 2014 01:42:08 GMT

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

Re: Store listbox multiple selected value into variables or array

JonnyPoole — Wed, 10 Sep 2014 02:16:24 GMT

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

topic Store listbox multiple selected value into variables or array in QlikView

Store listbox multiple selected value into variables or array

Re: Store listbox multiple selected value into variables or array