Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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;
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
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.
Hi,
I have attached the screen shot in the orginal post..
Can you look and advise me..
Regards
Joe
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
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
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
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