topic Re: Can we Convert The Default Calender in QlikView

Can we Convert The Default Calender

Karim_Khan — Mon, 17 Aug 2015 08:47:32 GMT

Can we Convert The Default Calender into Customize calender and How?

Re: Can we Convert The Default Calender

MK_QSL — Mon, 17 Aug 2015 10:06:55 GMT

No !

You need to use (may be) extension object to change it.

Re: Can we Convert The Default Calender

qlikviewwizard — Mon, 17 Aug 2015 11:03:30 GMT

What is the mean of default calendar?

Re: Can we Convert The Default Calender

qlikviewwizard — Mon, 17 Aug 2015 11:08:15 GMT

We can customise the caledar.

Re: Can we Convert The Default Calender

MK_QSL — Mon, 17 Aug 2015 11:09:25 GMT

What I understood is Karim wants customized calendar rather than the calendar available in Slider/Calendar Object.

Re: Can we Convert The Default Calender

avinashelite — Mon, 17 Aug 2015 11:12:58 GMT

As per my knowledge we cannot customize the Qlikview built calendar object but you can create your own custom object and play with the accordingly

Re: Can we Convert The Default Calender

MK_QSL — Mon, 17 Aug 2015 11:14:17 GMT

QlikView Wall Calendar.zip

Re: Can we Convert The Default Calender

Karim_Khan — Mon, 17 Aug 2015 11:35:15 GMT

Hi Avinash,

I want to play with our own customizecalendar.But My request was fro customizing the Built in Calendar

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='Rs. #,##0.00;Rs. -#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD-MM-YYYY';

SET TimestampFormat='DD-MM-YYYY hh:mm:ss[.fff]';

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

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

Re: Can we Convert The Default Calender

MK_QSL — Mon, 17 Aug 2015 11:48:08 GMT

SET DateFormat='DD-MM-YYYY';

SET TimestampFormat='DD-MM-YYYY hh:mm:ss[.fff]';

you can change to

SET DateFormat='DD-MMM-YYYY';

SET TimestampFormat='DD-MMM-YYYY hh:mm:ss[.fff]';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

Re: Can we Convert The Default Calender

Karim_Khan — Mon, 17 Aug 2015 11:55:18 GMT

But If Wanted to Start the Month as per my convenience then how can can I implement the same bcoz below code will not work for that

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

Re: Can we Convert The Default Calender

MK_QSL — Mon, 17 Aug 2015 11:57:21 GMT

You can create a customer order..

Load * Inline

[

Month, Order

Aug, 1

Sep, 2

etc.

];

If you want your Fiscal Calendar to be started from August, you need to do some coding in script for Fiscal Year/Month. Use below link for the same..

Fiscal Year

Re: Can we Convert The Default Calender

qlikviewwizard — Mon, 17 Aug 2015 11:59:04 GMT

Create INLINE table like this:

Calendar:

Load * inline

[

MonthNo,MonthName

1,January

2,Febraury

];