topic List box question in QlikView

List box question

Thu, 02 Feb 2012 13:55:29 GMT

hello,

i have created a list box from expression (can use only object id),

now i need to write a macro that peek all selected value from list box.

how can i do that?

thanks,

avi

jagan — Thu, 02 Feb 2012 14:01:12 GMT

Hi,

You can get selected field values by using the function

Ex: GetFieldSelections ( Year, '; ' ) - Returns the selected values of years separated by ;

Is there any specific reason to write macro? If need assign the function to a variable, and get the variable value in macro.

Regards,

Jagan.

Thu, 02 Feb 2012 14:03:22 GMT

hi,

the only problem is that is have used an expression and not a field in the list box,

and as i know GetFieldSelections get a field.

avi

jagan — Thu, 02 Feb 2012 14:58:54 GMT

Hi,

Use this expression below and assign it to a variable

=CONCAT(AGGR(Sum(COUNTER), F1), ';')

where

- AGGR(Sum(COUNTER), F1) - Expression used in listbox

- COUNTER and F1 are columns

now you will have the selected values in the list box separated by '";"

Now you can get the value in the variable in macro.

Hope this helps you.

Regards,

Jagan.

Thu, 02 Feb 2012 17:22:57 GMT

thank you!!!