topic Re: Variable value is disappearing in QlikView

Variable value is disappearing

qlikviewwizard — Tue, 29 Sep 2015 14:05:29 GMT

Hi All,

I am facing strange issue.I have created a variable called vStartDate (defn=Date(Trans_Date-365)

This variable is disappearing when I reload the application.Tried many times.

I have used export excel macros in the app.

Version:

Thanks in advance.

Re: Variable value is disappearing

marcus_sommer — Tue, 29 Sep 2015 14:19:50 GMT

Have you another variable with the same name into your script? Ctrl + F over all tabs will help to find it.

- Marcus

Re: Variable value is disappearing

Tue, 29 Sep 2015 15:04:47 GMT

define a variable in your script and reload, the variable should automatically come their

for example:

LET StartDate = num(date(YearStart(AddMonths(Today(),-24,0)),'DDMMYYYY'));

Re: Variable value is disappearing

sunny_talwar — Tue, 29 Sep 2015 15:11:35 GMT

Is this variable getting created in the script or the front end of the application? I would check its definition in the script.

Re: Variable value is disappearing

sunny_talwar — Tue, 29 Sep 2015 15:12:27 GMT

Re: Variable value is disappearing

Digvijay_Singh — Tue, 29 Sep 2015 15:14:55 GMT

Screen print says value of variable is disappearing, see whether it is initialized somewhere with null or something, but cannot say without looking at script. Is it happening with only this variable? if yes then seems to be something in the script is making the difference.