topic Date Dimension shall also show dates with no measures in App Development

Date Dimension shall also show dates with no measures

Tos — Sat, 16 Nov 2024 01:17:27 GMT

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?

Re: Date Dimension shall also show dates with no measures

RsQK — Fri, 16 Oct 2020 09:22:49 GMT

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

Re: Date Dimension shall also show dates with no measures

Gabriel — Fri, 16 Oct 2020 09:45:47 GMT

@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.

Re: Date Dimension shall also show dates with no measures

Tos — Fri, 16 Oct 2020 10:14:25 GMT

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.

Re: Date Dimension shall also show dates with no measures

RsQK — Fri, 16 Oct 2020 11:49:19 GMT

Could you share a sample .qvf?

Re: Date Dimension shall also show dates with no measures

Tos — Mon, 19 Oct 2020 06:01:28 GMT

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.

Re: Date Dimension shall also show dates with no measures

DionisiusAbadi — Sat, 16 Jul 2022 05:20:31 GMT

Hi, is this issue solved?