topic Re: Select data based on reference number in QlikView

Select data based on reference number

tamilarasu — Wed, 10 Dec 2014 02:10:21 GMT

Hi,

I have a below sample file and I want to know how to achieve this.

If I enter serial number in input box, the QV should select the data based on the serial number.

Say for example, My serial number is 5, then the Qv should select the 'E' in list box.

Please see attached qvd file for better understanding.

Thank you in advance.

jagan — Wed, 10 Dec 2014 04:02:08 GMT

Hi,

Refer attached file for solution. Used Variable Event Triggers in

Settings -> Document Properties -> Triggers -> Variable Event Triggers -> Select Variable -> On Change - Add Actions -> Select in Field

Regards,

Jagan.

tamilarasu — Wed, 10 Dec 2014 05:32:54 GMT

Thank you Jagan.