topic Re: Is there any Function to automatically select a Value? in QlikView

Is there any Function to automatically select a Value?

microwin88x — Fri, 07 Mar 2014 20:00:35 GMT

Hello! I have the following question:

Is there any way to automatically select a value from a field if I select another value from another field?

For example: I have fields like Zone and Office. 1 Zone has N Offices.

I want that if I select a particular Office, it automatically select the corresponding Zone.

I'm using the function ONLY (Zone) to get the corresponding Zone.

But I need to know if there's any way to select that Zone with a function...?

Thank you!!!

chiru_thota — Fri, 07 Mar 2014 20:11:49 GMT

Are you using a trigger to do this ?

=Concat(distinct Zone,',') will give you all Zones related selected offices

Colin-Albert — Fri, 07 Mar 2014 20:13:56 GMT

If your data model correctly associates the Zone and Office fields then there is nothing more to do.

Just add a listbox for Zone and another listbox for Office

Selecting an office will automatically indicate the associated zone via the green/white/grey logic.

Green shows the selected values and any associated values are white, unrelated data is grey.

maxgro — Fri, 07 Mar 2014 20:23:45 GMT

you can use field event trigger; you find it in

menu --> settings --> document properties --> triggers

and then

field events trigger --> on select --> add action --> select in field --> ......

but I think Albert solution is better