topic Partial Reload - Automatically resets variables ? in QlikView

Partial Reload - Automatically resets variables ?

Wed, 22 Jan 2014 18:49:44 GMT

Hi All,

I am trying to setup partial reload at a frequency of 5 mins. The data reload works fine but every time the document is partially reloaded on the server - the variables values are reset to its default values.

Any idea how I can setup partial reloads and not have the variables reset to default ?

Thanks!

PS: This is the same issue as http://community.qlik.com/thread/39123

Re: Partial Reload - Automatically resets variables ?

Nicole-Smith — Wed, 22 Jan 2014 20:56:29 GMT

You can write load script so that the variables are only set when there is a full reload:

IF IsPartialReload() = 0 THEN //If it is NOT a partial reload

set Variable = whatever;

ENDIF

Re: Partial Reload - Automatically resets variables ?

Wed, 22 Jan 2014 21:05:24 GMT

I tried this already but it doesn't work in this scenario.

In my application the variable values are constantly updated based on user selections. So a script based solution does not work

Re: Partial Reload - Automatically resets variables ?

Anonymous — Wed, 22 Jan 2014 21:17:02 GMT

QlikNY1911,

Is it only for partial reload? I think it happens with any reload (?).

Anyway, in a similar situation when the value had to be kept, I replaced variable with a field which contained all possible values. Field selections are kept for all users.
It was easy in my case because it was defined set of values. Maybe not good in your case.

Regards,

Michael

Re: Partial Reload - Automatically resets variables ?

Thu, 23 Jan 2014 15:17:23 GMT

Michael - Thanks, that does sounds like a good workaround, but not ideal for my scenario.

I am looking for a solution that allows me use this as a variable and not loose the values on a reload.