Break Line chart

[#1]

Hi Folks,

Is there any method in qlikview to break time series line chart on basis of data points.

Like I want my line chart to break if data is not present on some particular data point.

Regards,

Navdeep

[#2]

sales1 and Sales2 are two different fields, so using the if bellow ! works even for chaging the color of the line.

[Renato_Vieira]

Hey navdeep,

Not quite exactly what you wanted, but it might be pretty close. What I did was

• use the above function on the expression to create a second point after the last one that has a value on the line, so in this case the line doesn't drop to 0
• use the argb() function to color the sections of the line that have value and hide the parts of the line without value