topic Re: how to fill in missing dimension values in App Development

how to fill in missing dimension values

skyline01 — Mon, 14 May 2018 20:09:41 GMT

I am working in Qlik Sense. I have a very simple star schema data model. One of the dimension tables is for dates, with columns like month name and quarter. It is completed populated between some extreme date range.

I have a line visualization, with month name as my dimension (referenced from the date dimension table). My measure has a set expression in it. Because of the set expression, I have noticed that some dimension values (month names) do not appear. I have confirmed that the given dimension values are resulting from "missing" rows in my fact table.

I have a request to include all possible month name values in the visualization. How can I achieve this? I know that one solution would be to fill in the gaps in my fact table. However, that isn't feasible in my situation. Is there perhaps an alternative (and, hopefully, easier to implement) solution?

Re: how to fill in missing dimension values

aworrall — Mon, 14 May 2018 21:39:09 GMT

Hi, have you tried to create a master calendar?

http://youtu.be/ScdIQvWzVFs

Re: how to fill in missing dimension values

skyline01 — Mon, 14 May 2018 22:10:30 GMT

I'm not sure how a master calendar will resolve my problem. I have a completely populated date table. So, a master calendar will just be a replication of that table. The problem is that I have holes in my fact table. Because a set expression operates over the entire data model, the holes in my fact table effectively get replicated in my date table (at visualization time, not at data load time).