topic Is it possible to change Script Variables in the Front End in QlikView

Is it possible to change Script Variables in the Front End

rustyfishbones — Mon, 11 Aug 2014 12:39:41 GMT

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?

Re: Is it possible to change Script Variables in the Front End

Gysbert_Wassenaar — Mon, 11 Aug 2014 13:32:10 GMT

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

Re: Is it possible to change Script Variables in the Front End

rustyfishbones — Mon, 11 Aug 2014 13:44:06 GMT

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

Re: Is it possible to change Script Variables in the Front End

Gysbert_Wassenaar — Thu, 14 Aug 2014 08:46:17 GMT

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.