Get selected values into a variable

[frank1982]

Hi everyone,

I'm a QlikView rookie user.

I need to take the value selected from the following Listbox

(encoded like this):

=if(PRODOTTO like '*_PO*' or PRODOTTO like '*3F*' or PRODOTTO like '*PUNO*' or PRODOTTO like '*PUN orario*' or PRODOTTO like '*PNO*' or PRODOTTO like '*PUN 3 FASCE*','MULTIORARIA',if(PRODOTTO like '*2F*' or PRODOTTO like '*PK*','BIORARIA', if(PRODOTTO like '*1F*','MONORARIA',PRODOTTO)))

Into the following variable :

Unfortunately, the result is the code of the listbox, but not the value.

Could you help me?

Thanks a lot.

[olivierrobin]

hello

try to put =$(=getobjectfield(  ))

[marcus_sommer]

Try it with getfieldselections() instead of getobjectfield().

- Marcus

[frank1982]

Hi Marcus,

how can I use the function getfieldselection() in this case?

The values into the Listbox are not a particular field, but an encoding of the field 'PRODOTTO', explained through the following formula:

=if(PRODOTTO like '*_PO*' or PRODOTTO like '*3F*' or PRODOTTO like '*PUNO*' or PRODOTTO like '*PUN orario*' or PRODOTTO like '*PNO*' or PRODOTTO like '*PUN 3 FASCE*','MULTIORARIA',if(PRODOTTO like '*2F*' or PRODOTTO like '*PK*','BIORARIA', if(PRODOTTO like '*1F*','MONORARIA',PRODOTTO)))

Thank you

[Peter_Cammaert · Accepted solution]

But first, Franco, create an extra field in your load script that is filled with the outcome of your IF statement. Since the IF statement doesn't change at any time, it's better to do those static translations in your load script. And it reduces the load on the User Interface.

[frank1982]

Thank you!

I've insert the IF statement into my load script and after I've used getfieldselections() to take the value I want.