topic Re: Set a value to a field in QlikView

Set a value to a field

danosoft — Tue, 05 Dec 2017 09:56:18 GMT

Is possible to set a field (example field CD_FORNI) with a value clicking on a select box?

Example:

I click in a select box

i want when i click there to SET a variable, and SET field CD_FORN (this field cd_forn is in my table)

thanks

Re: Set a value to a field

prieper — Tue, 05 Dec 2017 10:05:46 GMT

Why would you do this in a listbox?

For Listboxes you cannot create an action (Selection, Search etc are actions enough)

Make it an Action:

Create a textbox and then go to

Properties -> Action -> Add -> Selection - Select in Field -> and enter the required data

Re: Set a value to a field

danosoft — Tue, 05 Dec 2017 10:09:02 GMT

I need to to in a list box becouse i have that for choice my value for do a search....

so you said me there i can't put an action....

how can i set a value in a field so with scripting language?

Re: Set a value to a field

danosoft — Tue, 05 Dec 2017 10:11:37 GMT

..becouse i thought, if i not have there the Action tab... i can put with scripting language in an Expression?

Re: Set a value to a field

prieper — Tue, 05 Dec 2017 10:19:11 GMT

As said,

you can create a textfield and then create the above action with the textfield to set a value (or any other searchexpression) for a field in your database.

Else please post a more concrete example.