Discussion board where members can get started with Qlik Sense.
Happy End Game.
May i know how to create a master calendar?
I've been searching in forum for some times. However there is no a good result.
Please find attached my qvf and excel file for your kind references.
I would like to create a master calendar for my scenario.
You seem to already have a table called CalendarTable, what is wrong with this?
Hi @sunny_talwar ,
Yes, i created the calendar table. But it does not work like my expected outcome.
Below are my tables. I would like to show every day of every month no matter there is or isn't technician working on those days.
For e.g.: The table show everyday but there is null value in technician. I do not want to show null value and there is null value in my data source.
But when I unchecked 'Include null values', it does not show every day of every month.
Without Null Values
It's not a matter of the master-calendar else how to create a suitable datamodel which contained all needed data. Not always but quite often it's necessary to Generating-Missing-Data if NULL's should be displayed.