Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

How to Reset Variables to Default Values?

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!

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: How to Reset Variables to Default Values?

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

4 Replies
Not applicable

Re: How to Reset Variables to Default Values?

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.

jolivares
Valued Contributor

Re: How to Reset Variables to Default Values?

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

MVP & Luminary
MVP & Luminary

Re: How to Reset Variables to Default Values?

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

Not applicable

Re: How to Reset Variables to Default Values?

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