topic Re: Show Gaps in Line Chart (Multiple Dimensions) in QlikView

Show Gaps in Line Chart (Multiple Dimensions)

ciaran_mcgowan — Wed, 12 Oct 2016 12:13:17 GMT

Hi,

I know this can be done in line charts with single dimensions but is there a way to show gaps in line charts where data is missing? I've created a chart that compares performance over weeks to that of their rivals/competition. Some weeks, users might not participate and I want to represent that a gaps in the line. Below is what I have at the minute.

But I want something more like this:

Is there a way to accomplish this and keeping the background data in grey without layering one chart over another?

Re: Show Gaps in Line Chart (Multiple Dimensions)

jonathandienst — Wed, 12 Oct 2016 14:22:37 GMT

Maybe using the forecolor property of the expression and a condition that paints the line in light gray if the current value or next value is null.

I suggest that you post a small sample containing some data and the object in question for more specific help.

Re: Show Gaps in Line Chart (Multiple Dimensions)

jcs_2015 — Wed, 12 Oct 2016 14:26:57 GMT

You'll need to create a Master Calendar that includes "all" dates and relate that to your date stamps in your data. No data for any point in time, with the Dimension as your Master Calendar date, would present "breaks" in the line.