topic Syntax for multiple selection for few values in a field? in QlikView

Syntax for multiple selection for few values in a field?

subin6600 — Wed, 23 Nov 2011 06:04:22 GMT

Hi,

I need the syntax for making multiple selections in a field to be selected and locked as the report is open.

Can any1 help me with this?

Re: Syntax for multiple selection for few values in a field?

lironbaram — Wed, 23 Nov 2011 07:45:52 GMT

the simple way is to use action

it should look something like:

first action : select in field , "Filed1" ,1

second Action: toggele select ,"Field1",2

third action : Lock field , "Field1"

put this action on the trigger on open

hope it helps you

Syntax for multiple selection for few values in a field?

subin6600 — Wed, 23 Nov 2011 09:34:04 GMT

Thanks for an answer,

But I have the field values in text format and i need to select 4 options from my list and lock it. I need the syntax to be used in the trigger- Select a field.

Re: Syntax for multiple selection for few values in a field?

lironbaram — Wed, 23 Nov 2011 09:42:53 GMT

hei

check this example

to see the set of actions

go to document properties->triggers->on open

Syntax for multiple selection for few values in a field?

subin6600 — Wed, 23 Nov 2011 09:49:44 GMT

Thanks Liron! it worked