topic How to select a value from a inline table based on name in QlikView

How to select a value from a inline table based on name

Thu, 29 Sep 2011 11:12:48 GMT

Hi Guys,

Has anyone come across the following issue,

I have an Input Box in which user selects a name and presses a button.

I have table which has 2 cols name,value.

When user selects name and presses the button then i want to display the value in a text box.

eg Input Box has values Employee Code,Dept Code etc populated from an inline table

Value for the above names will be empcode,deptcode etc populated using the same inline table

Now when user selects Employee Code then I want to display empcode from inline table based on the text.

Regards,

Sabarish

How to select a value from a inline table based on name

Thu, 29 Sep 2011 11:45:49 GMT

Input boxes are tied to variables. Add an 'On Input' trigger to the variable (see Document Properties>Triggers) so that a 'Selection/Select in field' action will set the value in the field table.

Regards,

Gordon

How to select a value from a inline table based on name

Thu, 29 Sep 2011 12:47:40 GMT

Also To select values from table i used

=Concat(Name,',')