Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display All Calendar month even if there is no data for the month

Hi, I have a table with some data. All data have  a creation date field. So i display in a table all my data create by month with the creation date with a count.

                         Jan. 2011     Feb. 2011     Mar. 2011 .     ...      Nov. 2011

CountCreate:          2                    8               12              ...          6

But for exemple; there is no data in December or in April; So the table will not display the month in the table. But i would like to display it even if there is no data.

                         Jan. 2011     Feb. 2011     Mar. 2011 .     ...      Nov. 2011     Dec. 2011

CountCreate:          2                    8               12              ...          6                    0

Is it possible to do that in the table and the chart ?

Thanks by advance

1 Solution

Accepted Solutions
Not applicable

I got it ...

In fact, i replace: =if(month([Date création DCP]), MMYYYY) by MMYYYY


I unchecked:

     - Delete if nul values (in Dimentions)

     - Delete nul values (in Presentation)

     - Delete missed Values (in Presentation)

     - Display all values (in Dimentions)

that's all

View solution in original post

10 Replies


Do you have dec 2011 in that month field? if so, use like this

untick suppress zero value in presentation tab.

untick suppress when value is null in dimension tab.

Hope it helps

Thanks & Regards,
Mayil Vahanan R
Specialist III
Specialist III

Create a Calandar tab amd Use a script like this


Load min(Link_Master_Calendar) as StartDate,

     max(Link_Master_Calendar)  as EndDate

Resident Table1;

Let vSTART = peek('StartDate',-1,'Range')-1;

Let vEND = peek('EndDate',-1,'Range');

Let vRANGE = $(vEND) - $(vSTART);

Let vTODAY = num(date(today()));

Drop Table Range;


Load $(vSTART)+recno() as Date



Load dATE(Date,'dd/MM/YYYY') as Link_Master_Calendar,

dATE(Date,'dd/MM/YYYY')      as FullDate,

Year(Date)                   as Year,

Month(Date)                  as Month,

Week(Date)                   as Week,

'Q'&ceil(Month(Date)/3)      as Quarter,

Month(Date)&'-'&right(Year(Date),2) as [Month Year]

Resident Dates;

Drop Table Dates;

Finally change Link_Master_Calendar to your actual date fields.

Not applicable

Thanks for help.

I tried that already it didnùt works. And yes my calendar is complete...

Not applicable

I'm using a special calendar for the script because i have to take the 15 days of prev month to the 15 days of the actual month. So in my script i have:

  In the code file cause i can't put the script here


Not applicable

up please

Creator II
Creator II

hi guillaumek,


                        can u ellaborate more....coz as per i cud understand.....u can make use of loosely coupled .....



Not applicable

I found a part of the question. In fact i checked "Display all the values" in dimention options of the table.

But it display me all the values of the calendar, like even if i make a selection on 2012 value, I will have 2006 - 2007 ....

So i made a calculated dimention: =if(year([Date création]), MMYYYY)

MMYYYY = Month + year.

But it display me only the data if there is a creation date for the month. So i have nothing in december in creation date, so i won't have december in my table.

And I want to have december even if it's displayed with value 0.

Do you have an idea?

Creator II
Creator II

hi guillaumek,


                     As per i can understand- u can do d following-

                     suppose u have atable wit values and dates..... suppose 2000 = 10,2001=14,2003=15.

                     now u have a calender which have dates 2000,2001,2002,2003,2004,2005..

                     so u want to see in chart as :

                     Dates     Values

                     2000        10

                     2001         14

                     2002         0

                     2003         15

                     2004          0

                     2005          0

                     now to get d above

                     1.-  dont link table wit calender date( kip both separate)

                     2 -  in dimension u take calender dates and in expression  - if (cal=table date, values)

                     3 - uncheck mark - from presentation tab - suppress zero values and suppress missing and null symbol  give '0' ans missing symbol give '0' instaed of '-'

    tatz it

i hope diz shud work......



Not applicable

Yes i think it's what i have:




LOAD * INLINE [Date création] ;

JOIN(MasterCalendar) LOAD

     [Date création],





RESIDENT TempMasterCalendar;



And the only one link with my data table is [Date création] ;

I have to have this for the charts and tables, for doing a relation with them.

in the table where there is [Date création] ;, I have some other information.

So it's like if [Date création] would be the "Values" you say I think.

I have a calculated dimention:

  =if(month([Date création DCP]), MMYYYY)

I unchecked:

     - Delete if nul values (in Dimentions)

     - Delete nul values (in Presentation)

     - Delete missed Values (in Presentation)

I checked:

     - Display all values (in Dimentions)

So do you have an idea please? did i make a mistake?