Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
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

10 Replies
Not applicable
Author

I got it ...

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

and

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