Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
JJ141
Contributor II
Contributor II

Show dates in table

Hi all,

Hope everyone is doing well. 

I have table below which highlights the usage per month from April 2020 to February 2021. As can be seen, some months such as May 2020 have been left out as there is no data for those months since the usage is 0 for those particular months. 

Is there a possible way, I can include those missing months along with 0 for the usage per month.

JJ141_0-1614112403871.png

Any help is greatly appreciated.

Labels (3)
1 Solution

Accepted Solutions
jwjackso
Specialist II
Specialist II

Create a Calendar that has all the time periods between the dates that you want in your dimension.

View solution in original post

2 Replies
jwjackso
Specialist II
Specialist II

Create a Calendar that has all the time periods between the dates that you want in your dimension.

View solution in original post

JJ141
Contributor II
Contributor II
Author

Thank you so much! Its worked 🙂