Date Dimension shall also show dates with no measures

[Tos]

Hello,

i want to know if there's a possibility to show a dimension (in my case the date dimension) even if there's no value/meassure for that dimension value. The checkbox with include NULL-Values does not work.

The formula for my measure is:

Sum([tickets.workdays])

I already found a thread and i think the guy will archive the same thing. But the solution does not realy work for my case or i don't unterstand it right. => Value in dimension disappears due to measure 

Can someone help me out on this or is it simply not possible?

[RsQK]

Do you have a master calendar within your data model? Typically one would resolve this by creating one.

https://www.tutorialspoint.com/qlikview/qlikview_master_calendar.htm

[Gabriel]

@Tos 

What you need is a master calendar. This will have all the dates, from min to max of the dates in your raw data.

There are plenty examples of how to create master calendar here in the community. 

[Tos]

Yeah we got a master calender, i forgot to say this. this is the real reason i don't understand why null values are not shown.

[RsQK]

Could you share a sample .qvf?

[Tos]

Unfortunately i am not able to create a .qvf from the enterprise edition. However i created a .qvs with example data.

As diagram i used a line chart, where the dimension is 'date_visual' and the measure is the variable 'formula_workhours'. Sorted by 'date_visual' with only checked checkbox 'sort numeric' for correct timestamp order.

If nothing is selected as well as year or month, i got all dimensions. However if one or more users are selected i got the problem described. Hope this will help.

[DionisiusAbadi]

Hi, is this issue solved?