topic Re: Selection in field through input box. in QlikView

Selection in field through input box.

Mon, 08 Oct 2012 09:50:28 GMT

Hi !

I am a beginer in qlickview programming.

I want to make a selection in one of my fields containing month-name. based on the input in input box. ie. On entering the month_number in an input box ,the corresponding month_name should get selected in the field.

I have tried to use the trigger event- action of selection on my input variable. Still i am not getting the desired result.

Can anyone please guide me??

Thanx.

Re: Selection in field through input box.

Gysbert_Wassenaar — Mon, 08 Oct 2012 10:19:07 GMT

Here's an example where a variable and an input box are used to select values smaller or equal than the variable. You should be able to figure out how to change it for your purposes.

Re: Selection in field through input box.

Mon, 08 Oct 2012 10:32:28 GMT

Thanks fr the help.. but i cannot open the file as i am using a personal edition version. the source files are not visible.

can u please share sme small example here itself....regarding as how to link the input box and the listbox.

Re: Selection in field through input box.

Gysbert_Wassenaar — Mon, 08 Oct 2012 10:53:17 GMT

In this screenshot I have added actions to the OnChange and OnInput triggers. If VAR1 is changed in the Inputbox, then the selection in Field B is changed to select all values smaller or equal to the new value of VAR1.

Hope this helps

Re: Selection in field through input box.

jonathandienst — Mon, 08 Oct 2012 11:06:11 GMT

Is there any particular reason for using an input box to select the month number?

The normal Qlikview approach would to use a list box for month and the user would make the selection from the listbox. No need for macros and/or actions. But perhaps you have good reason for not using the standard approach?

Regards

Jonathan