Setting variables in script vs document properties

[ciaran_mcgowan]

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.

[sunny_talwar]

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

[sunny_talwar · Accepted solution]

Another option is to load variables from a Excel file:

Managing Variables

[trdandamudi]

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.