Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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