Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ankitd_modi
New Contributor III

Line Chart - Dont want to show trendline for value 0

Hi All,

Need your help. I want to create a Line chart for Plan and Actual, but my trend line should stop where the value is "0" or in this case its "null". Please see below chart, the Actual line(in red) should stop at Q1 as the other values are 0 in the quarter. Am attaching the excel from which the chart is created. Is it possible in QlikView?

Graph.jpg

3 Replies
vishsaggi
Esteemed Contributor III

Re: Line Chart - Dont want to show trendline for value 0

Are you looking for this?

Capture.PNG

ankitd_modi
New Contributor III

Re: Line Chart - Dont want to show trendline for value 0

I have give wrong thing.. Sorry will re-post the request

vishsaggi
Esteemed Contributor III

Re: Line Chart - Dont want to show trendline for value 0

Ok, delete or close this thread. I have already responded on your new thread.

Community Browser