Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Skipping points on a line graph

Hi,

I have a line graph, where the data series per second is something like:

20,20,18,15,16,-1,15,16,20,-1,22

The -1's in this series are failures and I would like to show nothing there for that particular x-value. So the graph should be a line and then break and then start again. How would I achieve this in Qlikview?

Thanks in advance

2 Replies

Re: Skipping points on a line graph

You can use the Background Color expression of the chart expression for this. Click on the + in front of the expression on the Expressions tab. Select Background Color and enter an expression like if(sum(Value)=-1 or Below(sum(Value))=-1,White()). Replace sum(Value) with your chart expression. See attached example


talk is cheap, supply exceeds demand
salto
Valued Contributor II

Re: Skipping points on a line graph

Hello,

you could:

1.- use an expression for the graph like =if(Value<0,0,Value) so it will show zero when the value is below zero in the graph (remember to uncheck the "Supress zero values" in the chart properties). This is the example attached.

2.- Skip the Valuez below zero when you load the escript. They will not be shown in the chart.

Hope this helps.

Community Browser