topic Re: Setting variables in script vs document properties in QlikView

Setting variables in script vs document properties

ciaran_mcgowan — Mon, 25 Apr 2016 23:33:35 GMT

Hi,

Is there a difference between declaring variables in the script instead of the document properties?

I prefer using the script so I can easily search for and manage them but I've inherited apps where some are declared in the document properties, others in the script and is pretty messy in the larger qvws.

If I move everything to the script, can that have any adverse effects?

Thanks.

Re: Setting variables in script vs document properties

sunny_talwar — Mon, 25 Apr 2016 23:37:33 GMT

I have seen having trouble with variables which uses dollar sign. They seem to be evaluated in the script. The work around is to use # instead of $ and then replace # with $ sign. I guess just a extra step but seems to work without flow.

UPDATE: A link to refer to -> Qlikview: Variables, SET, LET and Dollar Sign Expansion | Hyunku's Blog

Re: Setting variables in script vs document properties

sunny_talwar — Mon, 25 Apr 2016 23:53:41 GMT

Another option is to load variables from a Excel file:

Managing Variables

Re: Setting variables in script vs document properties

trdandamudi — Tue, 26 Apr 2016 00:04:48 GMT

I prefer to load the variables from Excel into Qlikview, So that I have complete control.

The below link has a working sample:

Duplicate rows discarded when reloading Excel data by using FOR-NEXT loop.