topic Re: Issue with Year selection which gets resolved once QV server is restarted in QlikView

Issue with Year selection which gets resolved once QV server is restarted

Mon, 26 Jan 2026 18:19:17 GMT

Hi All, swuehl, Miguel Angel Baeyens, John Witherspoon

Henric Cronström Deepak Vadithala Henric Cronström

I am a facing a weird issue wherein the QV charts and tables get stuck for an year( eg 2014). These QV object does not refresh the numbers for 2013 provided 2013 is selected, and this is happening only for a particular year which is 2013. If I select 2014 or 2012 or 2011 etc etc the QV objects get refreshed.

Note: This is only the case when the file is deployed on Server

Known solution as of now: Once we restart the Production server everything gets rectified.

Can anyone help me out? Its been around 2.5 years since I am working on QlikView but I have never faced this sort of Problem

Any help will be highly appreciated

Thanks in Advance

Sagar Gupta

Re: Issue with Year selection which gets resolved once QV server is restarted

Mon, 07 Jul 2014 20:16:05 GMT

Hi,

Is so strange this issue... try to clean Year field with trim() and then specify you want to get this data like a number ... something like this:

Let vYear = Num(Trim(Year)); // If you declare variable in script editor

or just

Num(Trim(Year)) // Make sure don't tip "=" at the beginning if you declare variable in variable overview

Best regards.

Re: Issue with Year selection which gets resolved once QV server is restarted

ashfaq_haseeb — Tue, 08 Jul 2014 09:32:30 GMT

Hi,

From how long you get this error.

What version of QlikView you run?

Do you have some patched installed on QlikView server recently?

What is the current version of IE.

Regards

ASHFAQ

Re: Issue with Year selection which gets resolved once QV server is restarted

Wed, 30 Jul 2014 13:06:25 GMT

Hi ASHFAQ,

I am facing this issue since 1 month, possibilities are their that this issue might be present before I noticed it.

We have checked for patches in QV but we don't have any.

The version which we have on the dev as well as on prod server is 11.2 SR2.

The above mentioned issue is with both IE and Ajax plugin.

Please suggest in case of any possible resolution

Regards

Sagar Gupta

Re: Issue with Year selection which gets resolved once QV server is restarted

Wed, 30 Jul 2014 13:08:09 GMT

Hi Vasquez,

Thanks for your response, but I don't think that Trim() function will help because the length of the year field is restricted to 4.

Regards

Sagar Gupta

Re: Issue with Year selection which gets resolved once QV server is restarted

ashfaq_haseeb — Sun, 03 Aug 2014 06:34:38 GMT

Hi,

Can you share a sample to replicate issue.

Regards

ASHFAQ

Re: Issue with Year selection which gets resolved once QV server is restarted

qlikpahadi07 — Sun, 03 Aug 2014 07:15:54 GMT

Dear Sagar,

This is weird issue but as you said it's related with Server and once you restart the Production server it works,

try to delete all .PGO and .Shared,.META files and restart the server and see if it works.

Re: Issue with Year selection which gets resolved once QV server is restarted

Tue, 05 Aug 2014 10:53:05 GMT

Hi,

Thanks for your response

I will try this but I have a question, will doing this remove QV license? or are you aware of any sort unseen issue which may come up doing this step? The only reason of being cautious is that the file is on production server.

Regards,

Sagar Gupta

Re: Issue with Year selection which gets resolved once QV server is restarted

ashfaq_haseeb — Tue, 05 Aug 2014 11:26:00 GMT

Hi,

By deleting those files.

you have to re allocate licences and all the user created objects and bookmarks will be deleted.

Take proper backup first.

Regards

ASHFAQ