topic Re: Use a variable to make selection in a field in QlikView

Use a variable to make selection in a field

Tue, 13 Dec 2016 10:17:33 GMT

Hi,

I have a container, with two calendar objects, enabling users to make a selection basis a from and to date.

On the variables used in these objects I have added a 'select in field' action, specifying the field name where the selection should be done and added a >= & <= basis the from and to date. This works.

The application has several date fields; arrival date, registration date and report date, to name a few. I have listed these in an input box, storing the field name in a variable. I would like the user to select any of the date fields in this input box, and then by using the from/to 'date picker' make a selection on the chosen date field. The question is, how can I use this variable, to enable a selection to be made in the chosen date field basis the input box.

Any help is greatly appreciated, thanks!

Edwin

Re: Use a variable to make selection in a field

marcus_sommer — Tue, 13 Dec 2016 11:09:21 GMT

I think you could use your input-variable as fieldname within the selection-trigger.

- Marcus

Re: Use a variable to make selection in a field

Tue, 13 Dec 2016 11:58:39 GMT

Hi Marcus,

Thank you for your answer.

I use the screens as shown in the attached image - can I enter the variable (dateTest is the var storing the date fields) as field name here or should I add a script to the calendar object?

Kind regards,

Edwin

Re: Use a variable to make selection in a field

marcus_sommer — Tue, 13 Dec 2016 12:23:39 GMT

Try it with: [$(dateTest)]

- Marcus

Re: Use a variable to make selection in a field

Tue, 13 Dec 2016 14:12:49 GMT

Dear Marcus,

Thank you very much, it's working now!

Kind regards,

Edwin