Show all month in bar chart even without data

[Anonymous]

Hi guys,

I need to show all 12 months in a bar chart although my month dimension is based on data with only 3 months.

Any ideas how to get a calculated dimension to do that? Thanks!

[Sergey_Shuklin · Accepted solution]

Hello, Claudio!

Perhaps creating a calendar in the script will be the best solution. But if you don't lookin' for easy ways you can use a ValueList() function to achieve this. PFA.

Master Calendar Generation Script

[Peter_Cammaert]

Create a Master Calendar, just like Sergey suggested.

[Anonymous]

Thanks Sergey!

Just a little help with the valuelist function, can I use short monthnames as below? It shows 'no data to display' when I apply it.

My field 'mes_capas' comes from a month function, that's why I changed the date.

=pick(ValueList(

Dual('Jan',1)

,Dual('Fev',2)

,Dual('Mar',3)

,Dual('Abr',4)

,Dual('Mai',5)

,Dual('Jun',6)

,Dual('Jul',7)

,Dual('Ago',8)

,Dual('Set',9)

,Dual('Out',10)

,Dual('Nov',11)

,Dual('Dez',12)

),

Count({<mes_capas={"Jan"}, ano_fech={$(=Year(ReloadTime()))}>} qntd_capas),

Count({<mes_capas={"Fev"}, ano_fech={$(=Year(ReloadTime()))}>} qntd_capas),

Count({<mes_capas={"Mar"}, ano_fech={$(=Year(ReloadTime()))}>} qntd_capas),

Count({<mes_capas={"Abr"}, ano_fech={$(=Year(ReloadTime()))}>} qntd_capas),

Count({<mes_capas={"Mai"}, ano_fech={$(=Year(ReloadTime()))}>} qntd_capas),

Count({<mes_capas={"Jun"}, ano_fech={$(=Year(ReloadTime()))}>} qntd_capas),

Count({<mes_capas={"Jul"}, ano_fech={$(=Year(ReloadTime()))}>} qntd_capas),

Count({<mes_capas={"Ago"}, ano_fech={$(=Year(ReloadTime()))}>} qntd_capas),

Count({<mes_capas={"Set"}, ano_fech={$(=Year(ReloadTime()))}>} qntd_capas),

Count({<mes_capas={"Out"}, ano_fech={$(=Year(ReloadTime()))}>} qntd_capas),

Count({<mes_capas={"Nov"}, ano_fech={$(=Year(ReloadTime()))}>} qntd_capas),

Count({<mes_capas={"Dez"}, ano_fech={$(=Year(ReloadTime()))}>} qntd_capas)

)

[tajmohamed30]

Hi Claudio,

Recommending you to watch Understanding the Master Calendar - Qlik Sense and QlikView - YouTube

very easy to learn on how to fill the dates which has no data.

Thanks

Taj Mohamed

[Anonymous]

Got it, dimension was not set with the valuelist. Thanks again!