Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ivan_slobodian
Partner - Contributor
Partner - Contributor

How can I make an broken line on the chart in QlikVeiw?

I have months sales data by a lot of objects.

For example, in june 2018 we have not sales for one object. It isn't zero meaning, it is missing value. That is why sales dynamic from may to july 2018 should not be connected by line on the chart.

2 Replies
pradosh_thakur
Master II
Master II

if you want it be zero then

use alt(measure_field,0) as measure_field
or
if(len(trim(measure_field))=0,0,measure_field) as measure_field

then use it in the chart
Learning never stops.
mrybalko
Creator II
Creator II

You should use background color property for expressions to hide missing parts.

See example in attachment