topic Calendar is Not working in QlikView

Calendar is Not working

Tue, 06 Dec 2011 12:22:39 GMT

Dear All,

I have a strange issue, in my local machine I have created a application with a auto generated calender which is working fine,

when I run the same qvw in the server machine the calendar is not working.

Please help me urgently

Regards

Joe

Re: Calendar is Not working

Sokkorn — Wed, 07 Dec 2011 01:56:07 GMT

Hi vmjoe1978,

Try to check these format at the top of the script. Make sure date format in server is the same with your local machine.

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='DD-MM-YYYY';
SET TimestampFormat='DD-MM-YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Regards,

Sokkorn Cheav

Re: Calendar is Not working

Wed, 07 Dec 2011 06:06:08 GMT

Hello Sokkorn Cheav,

Thanks for your reply, Using the following code I can create a calendar in the server, when I press the calendar Icon it keeps mum and no action.

Using the same code in my local computer, its perfectly working fine...

I can not understand why its behaving like this.. Please reply me

Regards

Joe

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

CalendarGeneration:

LOAD * INLINE [

CalendarStart, CalendarEnd

01/01/2008, 01/01/2015

];

MinMax:

LOAD Max(CalendarEnd) AS MaxDate,

Min(CalendarStart) AS MinDate

RESIDENT CalendarGeneration;

LET varMinDate = Num(Peek('MinDate',0,'MinMax'));

LET varMaxDate = Num(Peek('MaxDate',-1,'MinMax'));

LET varToday = Num(Today());

UnlinkedCalendar:

LOAD

Date($(varMinDate) + RowNo() - 1) AS Calendar

AUTOGENERATE ($(varMaxDate) - $(varMinDate)+1);

DROP TABLE CalendarGeneration;

Re: Calendar is Not working

Sokkorn — Wed, 07 Dec 2011 06:31:01 GMT

Hi Joe,

You said "when I press the calendar Icon it keeps mum and no action". I'm not clear about this yet. Can you details on

1. <Calendar Icon> : Mean that calendar object in QlikView or other?

2. <Keep mum> : ?

3. <No Action> : It not effect to other object in QlikView? This one can be solve by link table.

Your script is ok. One more thing if you can print screen for the error on the server, so that it make easy to understand your issue.

Regards,

Sokkorn Cheav

Calendar is Not working

Wed, 07 Dec 2011 06:58:04 GMT

can u attach the qvw file so that i can test it on my machine, and understand what's the issue.

Moreover can you attach the screenshot of the erroro screen that comes when you try to open it on server.

Check one more thing that other qvw files are working perfect on server or not.

Re: Calendar is Not working

Wed, 07 Dec 2011 07:01:00 GMT

Hi,

I have attached the screen shot in the orginal post..

Can you look and advise me..

Regards

Joe

Calendar is Not working

Wed, 07 Dec 2011 08:48:33 GMT

first there is no association between unlinked calender and minmax .

second there is no need to make inline table to provide start and end date.

Do like this:

1. create variable as go to document properties -> variables -> click on new button -> name the variable. your variable gets created.

2. right click on sheet -> new sheet object -> select slider/calender object -> on general tab -> click checkbox variables -> select the variable you have created -> on general tab provide start date and end date which is the minimum and maximum date which you want to take in calender. Either you can hard code the date or provide any expression.

3. your calender object gets created. select any date from the calender.

4. to see the date take text object and provide expression:

=date(VariableName)

your date gets displayed.

regards

vijit

Re: Calendar is Not working

Sokkorn — Wed, 07 Dec 2011 09:16:48 GMT

Hi Joe,

Check QlikView version in server and your client machine. Does it the same version or whatever? Or try to reinstall QlikView on the server again.

Regards,

Sokkorn Cheav

Re: Calendar is Not working

Miguel_Angel_Baeyens — Wed, 07 Dec 2011 10:14:20 GMT

Hi,

Do you have any triggers in your production document? The calendar itself seems to be fine and working, but the problem seems to be in the calendar object. Are you triggering any actions or macros in the variables that are used by the calendars? How many different dates do you have?

Hope that helps.

Miguel

Calendar is Not working

Wed, 07 Dec 2011 11:32:21 GMT

Dear Miguel,

Thanks for your reply,

I am not using any triggers in the document, only in the server I can not use the calendar object.

Even I tried to create a sample calender, that is also not working, so finally in the server the calendar object is not functioning.

(Qlikview version 9.00 7440 8 SR3 64 bit Edition, its running in Windows 2008 R2 Standard).

The main idea is generating a calendar the user has to select the Start Date and End Date, is that any other way to implement, please advise...

Regards

Joe

Re: Calendar is Not working

Miguel_Angel_Baeyens — Wed, 07 Dec 2011 11:43:05 GMT

Hi Joe,

There are several bugs related to the calendar object in Ajax and Plugin documented in the release notes of v9 SR4. I'd recommend you to upgrade your version to the latest release of version 9 (SR7 build 07808) if possible, at least in a test server, so you can check whether the object behaves as expected or not.

Hope that helps.

Miguel

Re: Calendar is Not working

Wed, 07 Dec 2011 11:48:15 GMT

Dear Miguel,

Thanks a lot, I will test and let you know....

Regards

Joe

Calendar is Not working

Wed, 29 Feb 2012 13:02:04 GMT

I´m having the same problem with QV Server 11. Does any one have the same issue ?