topic Re: How can I hide line if adjacent value is null? in QlikView

How can I hide line if adjacent value is null?

Wed, 06 Jun 2012 10:38:26 GMT

Dear Gurus,

I created the line chart to see the market share trends and faced with the problem when by default the line will be drawn between two data points even though data points between them will be null. In this example it could be misleading as user will get the impression that market share between points A and B on the attached screenshot was growing, whereas in fact it went from A to 0% and consequently returned from 0% to point B.

Any ideas how can I implement interrupted line or in other words hide the interval from point A to B?

Would appreciate your suggestions. Thank you.

Re: How can I hide line if adjacent value is null?

vincent_ardiet — Wed, 06 Jun 2012 12:03:12 GMT

Hi,

Check in the Presentation tab of your line chart if the "Suppress Zero-Values" is checked. It can be the origin of your problem.

Regards,

Vincent

Re: How can I hide line if adjacent value is null?

jafari_ervin — Wed, 26 Dec 2012 12:18:41 GMT

I have the same problem.

if you can please solve my problem in this post

http://community.qlik.com/thread/69124

Re: How can I hide line if adjacent value is null?

Mon, 03 Jun 2013 14:58:26 GMT

I could use a solution to this problem also... "Suppress Zero-Values" wont solve this.

Re: How can I hide line if adjacent value is null?

Gysbert_Wassenaar — Mon, 03 Jun 2013 18:58:57 GMT

See here