topic Re: Variable behaves differently on Server in QlikView

Variable behaves differently on Server

Mon, 26 Jan 2026 18:19:17 GMT

Hi.

I am baffled. I've got a variable that works fine on my desktop and on a staging server, but once on the production access point, the variable comes up null (using the same data and filters.

The variable's name is vQBRFYstartMonthDate, as is defined as:

=Addmonths(IF($(vQBRFYstartMonth)=1,

NUM(makedate($(vQBRDYselectedYear),$(vQBRFYstartMonth)+11)),

NUM(makedate($(vQBRDYselectedYear),$(vQBRFYstartMonth)-1))),-11)

This returns a date.

On the server, the variable fails, but the funtion works find. Yet on my local file and on a staging server, the variable works fine.

What give? I hope I am not overloking something silly...

Re: Variable behaves differently on Server

Clever_Anjos — Tue, 29 Oct 2013 19:00:44 GMT

Let me ask a silly question

All others variables are set?

vQBRFYstartMonth

vQBRDYselectedYear

vQBRFYstartMonth

Re: Variable behaves differently on Server

Tue, 29 Oct 2013 19:15:28 GMT

Yes (One can never be too silly)

I have tested all three separately and they work fine, but anyways, the entire line works fine when called dirrectly, It's the variable that is failing (but only on the server). I have also tried to call the variable three different ways:

=vQBRFYstartMonthDate

=$(vQBRFYstartMonthDate)

='$(vQBRFYstartMonthDate)'

Re: Variable behaves differently on Server

Clever_Anjos — Tue, 29 Oct 2013 19:18:29 GMT

Where are using this variable? Try to put

=vQBRFYstartMonthDate into a textbox and check what it returns

Re: Variable behaves differently on Server

Tue, 29 Oct 2013 19:22:04 GMT

Thanks how I am testing them. i.e by putting them in a text box.

Re: Variable behaves differently on Server

Clever_Anjos — Tue, 29 Oct 2013 19:34:34 GMT

Did you try both plugin and ajax?

Re: Variable behaves differently on Server

Tue, 29 Oct 2013 19:43:04 GMT

Hadn’t tried Ajax. But I just did and it is the same problem.

Re: Variable behaves differently on Server

Clever_Anjos — Tue, 29 Oct 2013 19:59:30 GMT

I can´t see a reason.

The app is exactly the same? Or into your prod server you´ve reloaded the app?

Re: Variable behaves differently on Server

Tue, 29 Oct 2013 20:04:05 GMT

I am not sure I understand but I think the app is reloaded, since I am pushing a full qvw file to the server.

Re: Variable behaves differently on Server

Clever_Anjos — Tue, 29 Oct 2013 20:05:13 GMT

If you copy your production qvw and open it using your desktop, the issue persists?

Re: Variable behaves differently on Server

Tue, 29 Oct 2013 21:09:30 GMT

Woa. Got the file from the server and opened it on my desktop. The issue is no longer present.

But it is still present on the server.

What does this say?

Re: Variable behaves differently on Server

Clever_Anjos — Wed, 30 Oct 2013 11:18:12 GMT

Just checking if there´s some difference at data level.

What are the version of your Desktop and your server?

Re: Variable behaves differently on Server

Wed, 30 Oct 2013 12:56:59 GMT

Server = 11.20.11726.0 SR1 64bit

Desktop = 11.20.11718.0 SR1 64bit

Re: Variable behaves differently on Server

Wed, 30 Oct 2013 13:00:16 GMT

The production server has more data from a wider time period. But I am selecting a time period which has equivalent data.

Server = 11.20.11726.0 SR1 64bit

Client = 11.20.11718.0 SR1 64bit

Re: Variable behaves differently on Server

Clever_Anjos — Wed, 30 Oct 2013 13:20:21 GMT

Is it possible to upgrade to SR3?

Re: Variable behaves differently on Server

rajeshvaswani77 — Wed, 30 Oct 2013 13:39:03 GMT

Hi,

Could it be something to do with the system date time settings different on both the desktop and server?

thanks,

Rajesh Vaswani

Re: Variable behaves differently on Server

Clever_Anjos — Wed, 30 Oct 2013 13:52:12 GMT

Rajesh bring some light, thank you, it´s very good question

Re: Variable behaves differently on Server

Wed, 30 Oct 2013 18:02:43 GMT

I don’t control that. The IT team dictates which versions we need to use, in concordance with the server environment.

Re: Variable behaves differently on Server

Wed, 30 Oct 2013 18:04:31 GMT

Response from our admins:

These are document level settings and would remain the same in all the landscapes as long as it is the same document.

Also, date-time format for all the servers are the same. The only difference is the production server are east coast while all others are west coast based. But this should not be a problem.

Re: Variable behaves differently on Server

Clever_Anjos — Wed, 30 Oct 2013 18:10:28 GMT

I dont see any other reason.

Do you have a QlikTech support contact? Maybe it´s time to involving them.