topic Re: Show all month in bar chart even without data in QlikView

Show all month in bar chart even without data

Anonymous — Mon, 29 May 2017 13:38:24 GMT

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!

Re: Show all month in bar chart even without data

Sergey_Shuklin — Mon, 29 May 2017 15:57:04 GMT

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

Re: Show all month in bar chart even without data

Peter_Cammaert — Mon, 29 May 2017 16:03:09 GMT

Create a Master Calendar, just like Sergey suggested.

Re: Show all month in bar chart even without data

Anonymous — Mon, 29 May 2017 16:56:31 GMT

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)

)

Re: Show all month in bar chart even without data

tajmohamed30 — Mon, 29 May 2017 17:02:40 GMT

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

Re: Show all month in bar chart even without data

Anonymous — Mon, 29 May 2017 17:09:44 GMT

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