Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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

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

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.