topic Re: Showing Missing Time Data in QS in App Development

Showing Missing Time Data in QS

Fri, 11 Mar 2016 22:34:00 GMT

Hi All,

Does anyone know if the solution in the blog post below is possible in Qlik Sense? Sample he used attached.

Showing Missing Time Data in QV « BI Commons

Thanks!

Re: Showing Missing Time Data in QS

swuehl — Fri, 11 Mar 2016 23:03:06 GMT

I think there is even an easier solution for both QV and QS:

Use an expression like

=Sum(Sales)+Sum({1}0)

and disable 'suppress zero values' on presentation tab of QV chart properties.

Re: Showing Missing Time Data in QS

Wed, 23 Mar 2016 20:15:12 GMT

Thank you for this, this seems to work except for the 'suppress zero values' option in QS. Does this option exist? otherwise it just seems to flatline everything that should be a blank

Re: Showing Missing Time Data in QS

swuehl — Wed, 23 Mar 2016 20:55:41 GMT

I think the option is on AddOns - Data Handling in chart properties and called 'Show zero values' or similar.

I am not sure what you mean with 'flatline everything', though?

Re: Showing Missing Time Data in QS

Thu, 24 Mar 2016 14:44:12 GMT

I guess it means it creates a visible line along the axis of all the other zero'd out items. and when I remove 0 values, the issue of a mislead graph appears again. please see below and attached.

with the sum+ option there is a blue line at the bottom (aka flatlined):

with the show zero's option removed you have a misleading graph: