topic Re: Text Count and Line Charts in QlikView

Text Count and Line Charts

Wed, 14 Aug 2013 21:42:36 GMT

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?

Re: Text Count and Line Charts

CELAMBARASAN — Wed, 14 Aug 2013 21:49:12 GMT

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

Can you post your expression. If possible sample file?

Re: Text Count and Line Charts

rustyfishbones — Wed, 14 Aug 2013 22:08:35 GMT

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

Re: Text Count and Line Charts

Thu, 15 Aug 2013 16:18:47 GMT

Hi,

Used this statement on the script.

Set NullValue = '0';

NULLASVALUE *;

I used this expression on my line graph

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

Re: Text Count and Line Charts

Thu, 15 Aug 2013 16:22:48 GMT

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.

Re: Text Count and Line Charts

Thu, 15 Aug 2013 16:26:23 GMT

I also tried this expression.

Count([Violation Type])

Re: Text Count and Line Charts

Thu, 15 Aug 2013 16:29:32 GMT

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

Re: Text Count and Line Charts

CELAMBARASAN — Tue, 20 Aug 2013 14:50:16 GMT

Because of that only its treating zero as null.

Re: Text Count and Line Charts

Thu, 26 Sep 2013 18:24:40 GMT

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