topic Non continuous line in chart in QlikView

Non continuous line in chart

Tue, 26 Jul 2011 12:33:45 GMT

Hi, I have some charts in Excel that I want to make them again in Qlikview.

In particular I have a line chart in Excel that has null values in it. In that case the chart shows breaks in the line. I tried to draw a line chart in Qlikview with that behaviour with no luck. I think that is not possible to do that in Qlikview. Does anyone have the same problem???

I attached an example chart from Excel that I want to reproduce. It includes all the values to draw it.

Thanks!

Re: Non continuous line in chart

Wed, 27 Jul 2011 09:46:34 GMT

Hi,

You can check this example if that what you want

Best Regards.

Non continuous line in chart

rahulgupta — Wed, 27 Jul 2011 15:20:14 GMT

Hey Hi,

You can use '<s1>' in the line style under the expression tab.

Regards

Non continuous line in chart

Fri, 29 Jul 2011 12:18:18 GMT

Hi mona_qlik! Thanks for your answer... but I can't open the file. It seems to be broken, Qlikview says it cannot load that file. Could you upload a checked version of it again??

Regards!

Re: Non continuous line in chart

johnw — Sat, 30 Jul 2011 00:21:12 GMT

The attached file has examples for both a single dimension and two dimensions. They're not particularly straightforward, involving separate expressions for data points and lines, and then checking if the segment should be drawn by checking both points, and setting the color of the line to transparent if one of the points is missing. The two dimension case is even more complicated, with an additional data table and overlaying two charts.

So... not really supported in QlikView, but with enough effort, you can fake it up to look like you want.

Non continuous line in chart

Mon, 08 Aug 2011 14:29:55 GMT

Thank you John! It worked perfectly.

It's a pity that Qlikview is not capable of doing that transparently.

Thanks for sharing your knowledge in Qlikview!!!

Regards,

Ramiro!

Re: Non continuous line in chart

Thu, 28 Aug 2014 05:16:51 GMT

Hi Rahul,

I don't see this option; could you please elaborate?

Thanks,

Re: Non continuous line in chart

Mon, 02 Nov 2015 18:24:15 GMT

Rahul,

That just sets the line style to continuous, dotted, dashed, etc. It does not inhibit the line from continuing when a null datapoint is encountered.

Brian

Re: Non continuous line in chart

Wed, 07 Sep 2016 20:59:16 GMT

any way for me to load .qvw to QlikSense (doesn't show that file type is supported), you have in PDF/txt version? thanks

Re: Non continuous line in chart

Shivani — Fri, 06 Sep 2019 10:23:59 GMT

Could you please share expression used in color to make it transparent for Qlik sense