Text Count and Line Charts

[#1]

Hello Everyone,

I am fairly new to QlikView and have just ran in too a problem that i am having trouble resolving.

I am working on an app to display various safety violations on the course of a given time frame. The problem I am having is at certain points of time there are no violations reported creating a null value. I have tried to display the Null values as zeros but with limited success. When I select an individual violation type I see a zero point for the time frame but the line ignores it and proceeds to the next value, giving a false impression of a value in between. See the example below. Also these Null/Zero values do not display when multiple violations are selected. Does anyone know how to fix this?

[CELAMBARASAN]

If it is zero sure it will draw a line to it.

Can you post your expression. If possible sample file?

[rustyfishbones]

Maybe you have ticked the box to Suppress when value is null() ??

[#4]

Hi,

Used this statement on the script.

Set NullValue = '0';

NULLASVALUE *;

I used this expression on my line graph

Count ("Alt([Violation Type],0)")

[#5]

No I had that unticked. I am able to see the nulls as zero when an individual selection is made, just not when multiple or all possible selections are displayed. The big issue is that the line ignores the zeros and proceeds to the next value.

[#6]

I also tried this expression.

Count([Violation Type])

[#7]

Upon further review I had discovered this abnormality. The line ignored the value and only plotted null/zero values.

[CELAMBARASAN]

Because of that only its treating zero as null.

[#9]

I have resolved the issue. It had to due with the source file.