topic Re: Line Chart - Non continuous Value in QlikView

Line Chart - Non continuous Value

Anonymous — Wed, 08 Mar 2017 21:55:08 GMT

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 Q2(200) as the other values are 0 in the quarter. Am attaching the excel from which the chart is created. Is it possible in QlikView?

Dimesion used in Chart:- Qtr_GraphFlag

Expression used in chart:- =sum(if(GraphStatus='Run',GraphPlan)) -- Blue line

=sum(if(GraphStatus='Run',GraphActual)) -- Red Line

Re: Line Chart - Non continuous Value

vishsaggi — Wed, 08 Mar 2017 22:11:30 GMT

Check this? Using Line Chart.

Dim:

Qtr_GraphFlag

Expr:

Plan: = Sum({< GraphStatus = {'Run'} >}GraphPlan)

Actual: = Sum({< GraphStatus = {'Run'} >}GraphActual)

Re: Line Chart - Non continuous Value

sergio0592 — Wed, 08 Mar 2017 22:25:01 GMT

Try supress zero value in Presentation tab. Is that you are trying to achieve?