topic Re: Keep variables values after the reload in QlikView

Keep variables values after the reload

Benbassou — Wed, 22 Nov 2017 13:45:41 GMT

Hello,

I have a problem with variables when app get reloaded.

Let me use a simple example to understand the stuff:

- Suppose that i have a document with a variable vTest.

- I publish the document on the server with the variable vTest configured with default value 1

- A user modifies the contents of the variable [vTest] to 5. If, during user's analysis, the document is reloaded on the server (data is updated), the content of the variable is automatically set to the default value 1.

I don't wanna this behaviour, i need to keep the user defined value 5 even after the reload

Does anyone have had that problem before and how to keep variables values ?

Thank you for the help

Re: Keep variables values after the reload

Anil_Babu_Samineni — Wed, 22 Nov 2017 13:50:34 GMT

Describe more related how user going to select, I mean with in Input box?

Re: Keep variables values after the reload

Benbassou — Wed, 22 Nov 2017 13:55:34 GMT

Hi Anil,

The variable value is changed with button actions and not input box.

Re: Keep variables values after the reload

Mark_Little — Wed, 22 Nov 2017 13:55:54 GMT

Hi,

How are you defining a vairable?

I would guess that you are defining in Script something like

LET vTest = 1;

Comment out the line in the script, this should stop it being changed at reload and keep the last value entered.

If this is no the case you probably have a trigger set up to reset it.

Mark

Re: Keep variables values after the reload

jpenuliar — Wed, 22 Nov 2017 13:57:10 GMT

you probably are trying to achieve something like this:

Save variable VALUE from application to text, csv, qvs, or qvd file

Re: Keep variables values after the reload

Benbassou — Wed, 22 Nov 2017 14:13:02 GMT

Hi Mark,

I'm actually not initialize the variable in script, and i dont have any triggers in application.

i use this steps to create a variable

Settings -------> Variable Overview --------------> Add

and to change a variable value i use button action

thank you

Re: Keep variables values after the reload

Mark_Little — Wed, 22 Nov 2017 14:35:19 GMT

Hi again,

Probably down to the reload.

When you reload an app is the application moved from a Source Doc's folder to a User Doc's Folder?

I think you will find the Document your loading from has the variable set to 1 and the Document being viewed by your user is being replaced with the reloaded one.

A quick way check for this is to change the variable in the source document and see if on the next reload the number changes.

If this is the case i don't think there is an easy way to change this, sorry.

Mark

Re: Keep variables values after the reload

Benbassou — Thu, 23 Nov 2017 17:16:33 GMT

Hello Mark,

Yeah, i tried that. After every reload, the value of the variable back to default value. 😕

Actually, i think it's not only about variables but all app objects are reset to original version after every reload, for exemple when i move or i change an text object, the value and the location backs to default after the reload.

thank you

regards,

Idriss

Re: Keep variables values after the reload

Benbassou — Thu, 23 Nov 2017 17:21:51 GMT

Hello Jonathan,

Do you mean, that i should save my variables values with a macro in a file, and reset them later with script during the reload ?

regards,

Idriss

Re: Keep variables values after the reload

jpenuliar — Thu, 23 Nov 2017 17:30:57 GMT

i suppose that can be done with a macro.

This example allows editing value of a variable and saving to qvd by Reload action;

Loading Data into Input Boxes

Re: Keep variables values after the reload

jpenuliar — Thu, 23 Nov 2017 17:33:52 GMT

I couldn't find the article outlining how to use Google Sheets for inputting Variable values and the Qlik app to load the variables from Google Drive.

Re: Keep variables values after the reload

Benbassou — Thu, 23 Nov 2017 17:55:26 GMT

it's really a very good idea but in my case the application is used by several users and the value of the variable varies according to each one of them.

In the script its hard to update variable value according to each users or there is a method to do that ?

thank you,

Best regards,

Re: Keep variables values after the reload

sauliusr — Fri, 24 Nov 2017 06:22:25 GMT

Just mark this variable for inclusion in bookmarks and it will survive reloads. (Settings > Document properties > Variables > Settings for Selected Variable > Include in Bookmarks).

Re: Keep variables values after the reload

Benbassou — Fri, 24 Nov 2017 08:45:05 GMT

Thank you very much Saulius

It's exactly what i was looking for.

Re: Keep variables values after the reload

morenoju — Mon, 11 Feb 2019 13:58:10 GMT

Hi, do you know of any way to do this in Qlik Sense?

Re: Keep variables values after the reload

michael_klix — Tue, 14 Sep 2021 15:39:29 GMT

Any response meanwhile how it works in Sense? I would like to use a user defined variable during a user-triggered partial reload, but it seems during the reload, a variable that is defined in the frontend does not exist.