Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
raju_salmon
Creator II
Creator II

Calander Issue in QMC

Hi,

I have attached QVW and QVD for reference.

I have created calendar object. And based on start date and end date selection, dates are selecting correctly. For all months and all years.

The same QVW i have run in QMC and cross verified in Access point.

There is an issue with Nov and Dec month (every year) selection while checking in Access Point.

When i am selecting any date in Nov and Dec month, it is getting selection one month before.

Ex: I am trying to select Nov 14th 2014 then automatically calendar object picking the Oct14th 2014.

      I am trying to select Dec 28th 2015 then automatically calendar object picking the Nov 28th 2015.

This problem is only with Nov and Dec months of every year.

Is the issue with my QVW or QMC???

Can any one help me on this?

Thanks,

Raju

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Running QlikView Server 11.20SR8?

There was a calendar bug in QlikView Server that behaved like what you are explaining. Very annoying indeed.

Upgrade to a later release (it was fixed in SR9, but SR12 or SR13 would be even better)

Best,

Peter

View solution in original post

16 Replies
raju_salmon
Creator II
Creator II
Author

Can anyone see whether my calendar object creation is correct or not?

If it is correct, then i will try to focus on QMC side to solve the issue.

Thanks.

HirisH_V7
Master
Master

Hi ,

Do check the attached app !!

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
raju_salmon
Creator II
Creator II
Author

Hello Hirish,

Thanks for response.

I have deployed your modified QVW and checked the issue in access point.

The same issue is available.

Can you please do a help to me, can you check it in access point from your end.

If the issue is not available at your end, definitely there is an issue with our QMC. If you get the same issue, then probably problem with QVW.

Please deploy the QVW in QMC  and check the calendar object by selecting NOV or DEC date in access point.

Thanks a lot.

Raju

HirisH_V7
Master
Master

Hi,

Its working fine . please do check your server date format and application date format in some cases this may also cause such issues.

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
raju_salmon
Creator II
Creator II
Author

Oh really, are you able to select dates in access point??? Nov 2015 and Dec 2015 correctly???

Then the problem with my QMC.

May i know where can i check the date format in QMC?? I dont think this may cause issue, however i will cross check. Thanks for your help Hirish.

raju_salmon
Creator II
Creator II
Author

Hello Experts,

Based on Hirish information, the attached QVW has an issue in my QMC, whereas it is working fine with his QMC.

When i am selecting the NOV 2015 or DEC 2015 dates in access point, calendar object is considering one month previous date.

Can anyone help me what is the issue in QMC?

If possible can you cross check this QVW in your access point. Thanks alot.

-Raju

deepakqlikview_123
Specialist
Specialist

Hi,

Your sample QVW seems fine. there is no issue in dates it is showing perfectly.Please check your server date format

as suggested by hirish.

Thanks,

Deepak

raju_salmon
Creator II
Creator II
Author

Thanks Deepak, since i dont have much idea where i need to check, can please give me some information at what location i need to check?

Thank alot.

raju_salmon
Creator II
Creator II
Author

Thank you for help Friends. I will try to resolve this from QMC end. Anyone have more information, please post. Thanks.