Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Mr_A
Contributor
Contributor

Break the continuous line in Line Chart

Hi,

I want to break the line where null value in line chart. Used the logic: If(a=0,'',a)

It seems the applied login is not working properly, could anyone share your idea to break the continues line?

Mr_A_0-1696571714356.png

 

Labels (1)
3 Replies
rubenmarin
MVP
MVP

Hi, in chart properties ->layout -> presentation there is a drop-down for missing values, have you tried that options?

Mr_A
Contributor
Contributor
Author

Yes, but as per requirement we don't Wana suppress any null value.

For the reference, pls find the screenshot.

Mr_A_0-1696828550549.png

 

rubenmarin
MVP
MVP

Sorry, I though it was for Qlik Sense.

In QlikView I got close but there is a line I can't remove after the last dot of a serie.

PFA, it has the continuous option disable, and simulated using calendar that has all dates, and a combo chart, adding asum({1} 0) to the expression just to draw the dates, instead of {1} you can use a more dynamic filter based on selections.