How to show all months even if no data

[elie_issa]

Hi ALL,

Please check the attachment where we need to show all years ,quarters and months from 1-1-2017 till 31-12-2018 even if there is no filled data.

So when there is no data we need to show the cell in the table with no data.

Thanks for your support.

[elie_issa]

Hi Andres,

Are you sure that i have to use the below :

if(len(trim(Month))=0. Month)               AS     Month

or

if(len(trim(Month))=0 ,  Month)               AS     Month

and the above should be added to the calendar table or to the table from where i am getting my data.

thanks

[andrespa]

Hi Elie, sorry your right it's with ',' I had a typing error. And you should added to the master calendar.

Cheers,

Andrés

[sagarjagga]

you can try like this

SUM({$<[Year]={">={'2017'} <={'2018'}"}>}[Number Of Openings])

[Qliker35]

Make sure to contain ZERO VALUES is checked in the properties pane.