topic Re: How to Reset Variables to Default Values? in QlikView

How to Reset Variables to Default Values?

Fri, 18 Sep 2015 20:29:31 GMT

Is it possible to have a single action that resets all variables to default values vs having to manually input each "Set Variable" in the actions? Would like to avoid having to manually create an action for individual variables

Thanks!

Re: How to Reset Variables to Default Values?

Fri, 18 Sep 2015 20:55:26 GMT

Easy way is declare the variables in script or in an excel & load.

Hard way is use a macro to read variables from excel which will read default values.

Re: How to Reset Variables to Default Values?

jolivares — Fri, 18 Sep 2015 21:23:06 GMT

No... you have to clear one at a time.

Re: How to Reset Variables to Default Values?

marcus_sommer — Sat, 19 Sep 2015 08:49:59 GMT

You could use a bookmark for this - the values from variables could be included in a bookmark if by each variable the option "store in bookmark" is enabled.

- Marcus

Re: How to Reset Variables to Default Values?

Wed, 23 Sep 2015 20:43:42 GMT

Thanks Marcus!!

I was able to store the default values for the variables using the bookmarking feature and a hidden input box. What I also did to take it a step further and "automate" the reset was to have the sheet apply the bookmark on activation.

-Jason