3 Replies Latest reply: Mar 8, 2017 5:13 PM by Vishwarath Nagaraju RSS

    Line Chart - Dont want to show trendline for value 0

    Ankit Modi

      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