Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, swuehl, Miguel Angel Baeyens, John Witherspoon
Henric CronströmDeepak VadithalaHenric 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
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.
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
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
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
Hi,
Can you share a sample to replicate issue.
Regards
ASHFAQ
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.
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
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