How to include weeks with no data on chart (Qlik sense)

[KarlaB]

Hi all!

I have a trend chart of minutes per week, (as I'm using fiscal weeks, I did a tablewith the relation date-fiscal week and asociated it with my minutes table as date-date) but the weeks with 0 minutes are missed (you can see as in WK22 and 25).

I already added "0"s on that weeks on my minutes table using random dates on that weeks, in order that sums are displayed as:

WK21 - 12

WK22 - 0

WK23 - 9

WK24 - 45

WK25 - 0

WK26 - 86

But after that, the weeks with sum 0 still missing. Also, I already checked this checkbox is marked.

I need "0"s weeks to be shown on the trend chart.

Thanks in advance for your repply and help.

[ggijben]

Hi @KarlaB , 

This can be solved by using a Master Calendar in your datamodel. This will generate all the dates between the first date and the last date. This means that week 22 and week 25 are also created.

Some more info about the Master Calendar:

https://community.qlik.com/message/745582#745582 

https://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar 

If you can share some sample data, i can provide an example of a Master Calender for your data.

[KarlaB]

Hi!

Thanks but I don't know how to script on Qlik Sense, i think this is for desktop app, haven't seen any script function on Sense.