topic Re: Create a calender in QlikView

Create a calender

Tue, 17 Mar 2015 12:35:43 GMT

Hello all,

I am using QV 11.20 version.

I have a calendar in the report which is linked to my data read from database.

But if for any specific date is there is no data, so the day is disabled.

e.g: for march if there is no data for 15th March since it was sunday, the day 15 in the report is not having data so it is showing disabled as in image

But still I want to show day 15 as enabled.

How can it be done?

Re: Create a calender

buzzy996 — Tue, 17 Mar 2015 16:44:51 GMT

tht's QlikView default functionality,if u have some data it will show white,if u selected the same object that will be green,if u dont ahve the data that should be gray.

i don not think so it's possible.

May i know why u want show as MARCH 15 white if u don't have data in back end?

Re: Create a calender

sunny_talwar — Tue, 17 Mar 2015 17:25:39 GMT

Are you creating a master calendar in your application? If you are then none of the day's should be blank unless you make a selection which then disable the dates which don't have data point. Can you let us know if this is happening when you make a selection or this is happening regardless?

For the master calendar you can use one of the many scripts available on the community. Here is what I usually use:

Temp:

LOAD Min(Date) as minDate, //Date field from your database

Today() as maxDate

Resident TempData;

LET vMinDate = Num(Peek('minDate', 0, 'Temp'));

LET vMaxDate = Num(Peek('maxDate', 0, 'Temp'));

DROP Table Temp;

TempCalendar:

LOAD

$(vMinDate) + IterNo() - 1 as Num,

Date($(vMinDate) + IterNo() - 1) as TempDate

AutoGenerate

1 While $(vMinDate) + IterNo() -1 <= $(vMaxDate);

MasterCalendar:

LOAD

TempDate as Date, //Call it the same name as the one in your database so that the calendar object links to your database

Week(TempDate) as Week,

Year(TempDate) as Year,

Month(TempDate) as Month,

Day(TempDate) as Day,

Weekday(TempDate) as WeekDay,

'Q' & ceil(month(TempDate) / 3) as Quarter,

'Q' & Ceil(Month(TempDate)/3) & '-' & Year(TempDate) as QuarterYear,

MonthName(TempDate) as MonthYear,

Week(TempDate)&'-'&Year(TempDate) as WeekYear

Resident TempCalendar

Order By TempDate ASC;

DROP Table TempCalendar;

LET vMinDate = Null();

LET vMaxDate = Null();

HTH

Best,

Re: Create a calender

Wed, 18 Mar 2015 05:48:26 GMT

Thanks to both of you for the response.

Shiva,

I have to generate PDF through publisher which is for the week.

So my requirement is to show a label in the report as 'Report for 15th March 2015 to 16th March 2015'.

But since 15th is disabled, it shows as 'Report for 16th March 2015 to 16th March 2015'.

So either I want 15th as enabled or somehow manage to show from 15th to 16th.

At the same time, when I generate the PDF for the day, it should show the label as '16th to 16th'.

sunindia,

ya I have created a master calender whose date is linked to database field and due to which 15th is getting disabled.

Re: Create a calender

jonathandienst — Wed, 18 Mar 2015 06:17:23 GMT

Grey does not mean "disabled", it means "not possible with the current selections" and this is standard QV functionality. As there is no data for the 15th in 2015, it is not a possible value while 2015 is selected.

This is useful information for the user, why would you want to conceal it from the user?

HTH

Jonathan

Re: Create a calender

buzzy996 — Wed, 18 Mar 2015 10:28:01 GMT

Hi,

It's not possible to show data in chart (if u don't have) but u can manage from ur chart title or pdf name as "Report for 15th March 2015 to 16th March 201".