topic Re: How can I assign a default value to input box so it is set on the document load in QlikView

How can I assign a default value to input box so it is set on the document load

Wed, 26 Mar 2014 06:23:18 GMT

I have an input box that defines the date for analysis. It can be changed by the user to redraw the charts. How can I set the value that contains the input box on the document load to be the current date? Thanks in advance!

Re: How can I assign a default value to input box so it is set on the document load

its_anandrjs — Wed, 26 Mar 2014 06:26:46 GMT

Use a variable like vCurrent = Today() and use this variable in the input box. It always show current date value and if you have to find from any field then use peek function.

Hope this helps

Thanks & Regards

Re: How can I assign a default value to input box so it is set on the document load

Wed, 26 Mar 2014 07:38:42 GMT

It is not convenient as I can't apply neither input constraints nor number format settings to such input box. Is there a kind of event driven solution? Like vba windows apps function for events: Onload, etc.

Re: How can I assign a default value to input box so it is set on the document load

Wed, 26 Mar 2014 08:06:29 GMT

You mean you want the input box to show current date whenever the document is opened?

If so, then you can create a variable as suggested by Anand and write an action OnOpen of the document. Say your variable is :

vCurrent = Today()

Then write the following action,Go to Settings--Document Properties--Triggers tab, then in Document Event Triggers, add an action :

Action Type : External

Action : Set Variable

Write the variable name and the value in respective boxes.

Hope this helps!

Re: How can I assign a default value to input box so it is set on the document load

Wed, 26 Mar 2014 08:43:44 GMT

That does work! Thanks a lot!