topic Re: Master calendar granularity in App Development

Master calendar granularity

Tue, 04 Jul 2017 16:07:13 GMT

Hi everybody,

I have found a cool tutorial on how to build a master calendar by Micheal Tarallo (Understanding the Master Calendar - Qlik Sense and QlikView - YouTube)

Its very useful, however, I'm trying to apply that concept in one of my dashboards but failing to find the right way. I have tried to build on top of the tutorial dashboard (attached) but I've observed the same behaviour. I have notice that if I pull the your PRODUCT_ID into the dashboard as a filter (that's basically what I'm trying to implement on my dashboard) the calendar doesn't really keeps doing what its suppose to (fill gaps with the empty date) when you filter it by product. Instead, it only plots the days that contains data, which is exactly what the master calendar tries to avoid.

Would anybody be so kind to share some wisdom and save me from insanity please ?

Nothing selected (oct showing blank [ GREAT ]);

Product_ID 15 selected (Gaps back into play [NO BUENO]);

Thanks in advance

Antonio

Re: Master calendar granularity

Michael_Tarallo — Fri, 07 Jul 2017 15:28:36 GMT

Taking a look

Re: Master calendar granularity

Michael_Tarallo — Fri, 07 Jul 2017 16:04:43 GMT

OK I see what you are saying - when you select a ProductID for example you only see the dates where a product was sold and not a continuous axis.

This is by design - as it is associating the values that are selected - however there should be a workaround for this. Many I searched for state needing to load 0 values manually for measures that do not have a value - and then use intervalmatch() - however let me check with HIC to see if there is a better / easier way.

hic‌ - can you assist? - When using a Master Calendar - how can you get it to fill in the missing date values when a selection occurs?

Re: Master calendar granularity

hic — Tue, 11 Jul 2017 10:55:53 GMT

When you make a selection, some dates get excluded, and these are by default NOT shown on the x-axis. I can assure you that this is the way you want it to work in most cases - in cases where the dimension is discrete and non-numeric.

But you are right that dates are different: These are numeric and you want to show them spaced according their numeric value, so you get the proper gaps. To get this, you should check "Use Continuous Scale".

Then you will get the spacing you want. For line charts there is however one more problem: A line will be drawn straight across the gap, connecting the data points. But you most likely want the gap to be empty. For this, there is a small trick: Change the measure to Sum(Sales) + Sum({1} 0).

HIC

Re: Master calendar granularity

Michael_Tarallo — Thu, 13 Jul 2017 16:37:43 GMT

Thank you HIC - this is perfect.

I attached another sample to the post using Sum(Sales) + Sum({1} 0) as the measure:

scroll with scroll wheel on mouse:

Re: Master calendar granularity

jaws1990 — Fri, 02 Oct 2020 15:00:00 GMT

This is a good solution to getting 0 values for those missing dates however it causes the x axes to always be from the minimum date dimension to the maximum date value.

SUM(Sales) + SUM({1} 0)

Normally when you apply the filters the x axes would shrink as appropriate. Any ideas on how to get around this or can we only have 1 or the other.

Without + SUM({1} 0)

Re: Master calendar granularity

jaws1990 — Thu, 12 Nov 2020 08:16:56 GMT

I managed to work out a way to be able to filter on the x axes and keep 0 values where there was no data for that month.

So instead of + SUM({1}0) I used

+ SUM({1<xAxisDimension={"$(=If(IsNull(GetFieldSelections(xAxisDimension)), '*', GetFieldSelections(xAxisDimension,'","')))"}>}0).

Hope it helps someone.