Create a calender

[#1]

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?

[buzzy996]

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?

[sunny_talwar]

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,

S

[#4]

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.

[jonathandienst]

Hi

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

[buzzy996]

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".