topic Re: Default value in a variable in QlikView

Default value in a variable

Mon, 23 Sep 2013 05:45:33 GMT

I have an Input Box which is linked to a variable, such that if I change the value in the input box, that value is assigned to the variable.

I want to have a default value(based on an expression) assigned to this variable everytime the document is opened but I am unable to figure this out?

Later the user can change the variable value from the Input Box, which anyways is working fine.

Thanks for the help,
Sagar

jagan — Mon, 23 Sep 2013 09:23:58 GMT

Hi,

Try using Document triggers

Document Properties -> Triggers -> On Open -> Add Action -> External -> Set Variable -> Give variable and Expression in corresponding text boxes.

Hope this helps you.

Regards,

Jagan.

Mon, 23 Sep 2013 09:28:32 GMT

Variable has to be set in document properties.

Using the OnOpen trigger - the variable will get the assigned value when opening the document

Mon, 23 Sep 2013 09:33:18 GMT

Thank you Jagan and Erik. The solution works fine.

Regards

Sagar