topic Get selected values into a variable in QlikView

Get selected values into a variable

frank1982 — Thu, 22 Mar 2018 16:15:08 GMT

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.

Re: Get selected values into a variable

olivierrobin — Thu, 22 Mar 2018 16:47:48 GMT

hello

try to put =$(=getobjectfield( ))

Re: Get selected values into a variable

marcus_sommer — Fri, 23 Mar 2018 11:36:48 GMT

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

- Marcus

Re: Get selected values into a variable

frank1982 — Fri, 23 Mar 2018 11:50:13 GMT

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:

Thank you

Re: Get selected values into a variable

Peter_Cammaert — Fri, 23 Mar 2018 12:08:23 GMT

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.

Re: Get selected values into a variable

frank1982 — Fri, 23 Mar 2018 13:37:44 GMT

Thank you!

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