topic Re: Calander Issue in QMC in QlikView

Calander Issue in QMC

raju_salmon — Mon, 18 Jan 2016 07:09:14 GMT

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

Re: Calander Issue in QMC

raju_salmon — Mon, 18 Jan 2016 09:59:29 GMT

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.

Re: Calander Issue in QMC

HirisH_V7 — Mon, 18 Jan 2016 10:18:17 GMT

Hi ,

Do check the attached app !!

HTH,

Hirish

Re: Calander Issue in QMC

raju_salmon — Mon, 18 Jan 2016 10:33:28 GMT

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

Re: Calander Issue in QMC

HirisH_V7 — Mon, 18 Jan 2016 10:47:45 GMT

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

Re: Calander Issue in QMC

raju_salmon — Mon, 18 Jan 2016 10:51:53 GMT

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.

Re: Calander Issue in QMC

raju_salmon — Mon, 18 Jan 2016 12:47:57 GMT

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

Re: Calander Issue in QMC

deepakqlikview_123 — Mon, 18 Jan 2016 15:24:03 GMT

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

Re: Calander Issue in QMC

raju_salmon — Mon, 18 Jan 2016 16:13:32 GMT

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.

Re: Calander Issue in QMC

raju_salmon — Tue, 19 Jan 2016 00:49:27 GMT

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

Re: Calander Issue in QMC

HirisH_V7 — Tue, 19 Jan 2016 03:43:16 GMT

Hi ,

you please check your server System date format, If It is 'DD/MM/YYYY' the same Date format should be Specified in your application.

Do check this,

Hope this helps,

Hirish

Re: Calander Issue in QMC

raju_salmon — Tue, 19 Jan 2016 04:12:19 GMT

I am sorry to not understanding it clearly. In my script, i have date format MM/DD/YYYY.

However i do not know where i need to check this QMC. Even i am families with QMC, really i have no idea the exact location to check this.

Do i need to check this at triggers while scheduling it? or anywhere under system tab?

Thanks.

Re: Calander Issue in QMC

HirisH_V7 — Tue, 19 Jan 2016 04:33:42 GMT

Hi,

open your qlikview Server and Check the date format of the Server.

It should Be same as you mentioned(MM/DD/YYYY)

HTH,

Hirish

Re: Calander Issue in QMC

t_chetirbok — Tue, 19 Jan 2016 06:40:02 GMT

Hello!

Can you post some screenshots? What you want to see and what you see.

It can help us to tell you something more.

Re: Calander Issue in QMC

raju_salmon — Tue, 19 Jan 2016 13:03:50 GMT

Hi Tatsiana,

Thanks for your help, the problem is explained above. Please see once and Please find the attached screenshot as well.

Thanks.

Re: Calander Issue in QMC

Peter_Cammaert — Tue, 19 Jan 2016 13:56:43 GMT

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

Re: Calander Issue in QMC

raju_salmon — Wed, 20 Jan 2016 05:04:35 GMT

This is an excellent information Peter. Thanks alot.