Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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
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?
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: