topic Inline Selection to Field in QlikView

Inline Selection to Field

slondono — Wed, 24 Feb 2016 14:18:54 GMT

Hi guys

I have a problem here.

This is an Inline:

And this is the Field:

I need that the final user doesnt have the posibility to select 'EPM', so i created an inline without this choise. Now i need to communicate the Inline with the Field, i mean...When i selecting 'URABA' in the Inline, automaticly select URABA in the field.

The objetive of this is simple, the user will not have the posibility to selecting EPM

Thanks to all

Re: Inline Selection to Field

Gysbert_Wassenaar — Wed, 24 Feb 2016 17:05:40 GMT

Expand your inline table with the original field:

LOAD * INLINE [

_Filiales, Filial

MALAMBO, MALAMBO

NACIONALES, NACIONALES

ORIENTE, ORIENTE

URABA, URABA

];

Then simply use the _Filiales field for the listbox for the user. You won't need any tricks to make selections in the Filial field. It will always have only the possible values that match the selection in the _Filiales field.