Is it possible to change Script Variables in the Front End

[rustyfishbones]

Hi All,

I have the following Variables in the Script

I want to create a front end in the Extraction to change the Value of the Variables

like below

So if I click the check box it will change the variable to 1 and then it would load the .qvs file that contains the script and then

extract the data.

Is this possible? or am I wasting my time?

[Gysbert_Wassenaar]

It's possible, but reloading requires Qlikview Desktop. And you need to open the file directly. Open in Server will not work.

[rustyfishbones]

Thanks

So I can change the Variable Value in the Front end?

I have tried adding the Variable in an Input box and changing the Value from 0 to 1 and it does the keep the value obviously, as the script 0 value keeps.

Do you have an example where  this works

Regards

Alan

[Gysbert_Wassenaar]

See this post: Re: Reload Data based on a selected value

Make sure the script of your document doesn't set the value of the variable unless it's at the end of the script, i.e. before the variable is used for load statements. Otherwise your script will simply overwrite the value the user set.