Updating in bulk variables used in many qvws

[paul_ripley]

Hello

I have the same variables that I used across many apps that update the period.

I have to go into each app every month and update them with the new period.

Is there a way to do this in bulk? I believe there is away using excel but I don't know how to do this. Is that the best way?

Many thanks

Paul

[Gysbert_Wassenaar]

Instead of putting static values in those variables you could create expressions that calculate the values on the fly, for example based on the current date. That way you won't have to update them. They'll update themselves.

[paul_ripley]

Hi Gysbert

These fields can be changed at any time.  Just because we are now in the Aug doesn't mean the end period is always August, the user might want to look at March data whilse we are still in August.

However, usually around the beginning of the month I do roll forward the default period on the server.so I do need a way of updating these variables.

Kind regards

Paul

[vishsaggi]

Storing variables in an excel sheet and load them into your qv using load script like check this link:

How to import variables from excel or csv file ... | Qlik Community

[Gysbert_Wassenaar]

Then let the user update the variables. Add input boxes or calendar objects etc for them.

[paul_ripley]

They can do that, but this is just to have the variable default to the current period for when they open Qlikview

[Gysbert_Wassenaar]

Well, if there is no logic that can determine what the default value is then you're stuck with something like an excel file that you update whenever it needs to be updated and that's always loaded into the Qlikview document to give the variables their values.

[petter · Accepted solution]

You can place the variables in a separate script file that is shared in a shared folder and then include this file in every app that needs the same variables.

Make use of the:

$(must_include=...........);

In each of the load scripts.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/SystemVariable...

[paul_ripley]

Thanks All

I will have a go at this on Monday and let you know how I get on

[petter]

The AsOf-table could be an alternative way of approaching this....

https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table#start=50