topic Re: Bug in line chart? in QlikView

Bug in line chart?

Anonymous — Tue, 22 Apr 2014 18:43:54 GMT

I noticed a strange behavior in line charts when expression is "empty".

Here is a basic example.

I load this :

Date	Type	Value
1	Blue	1
2	Blue	2
3	Blue	3
4	Blue	2
5	Blue	5
6	Blue	3
1	Red	2
2	Red	5
3	Red	3
4	Red	1

Notice that for some "dates" Type "Red" is missing.

The basic line chart (displaying Value) works :

But if I change its style, bug with the colors!

At the date "5" I should have just the "Blue" area at 5 and no "Red" area

At the date "6" I should have just the "Blue" area at 3 and no "Red" area

Question is : Am I doing something wrong or is it a real bug?

Re: Bug in line chart?

its_anandrjs — Tue, 22 Apr 2014 18:54:54 GMT

No it is not a bug see the data for Red it is only for 1,2,3,4 Date

1	Red	2
2	Red	5
3	Red	3
4	Red	1

Same as for Blue it is for 1,2,3,4,5,6 Date that s why when you draw a line chart it shows only for 4 dates for Red. For same chart convert this into Bar Chart then you see the difference.

Regards

Re: Bug in line chart?

swuehl — Tue, 22 Apr 2014 19:01:06 GMT

Seems like a bug to me. The behaviour is different when you add dimension values for Red for those dates.

Re: Bug in line chart?

Anonymous — Tue, 22 Apr 2014 19:02:10 GMT

I don't get your answer.

As you noticed, Red has no value for dates 5 and 6 so why is there a red area for dates 5 and 6?

(And I don't want another type of chart I really want this style of line chart).

If I put 0 values on Red for dates "5" and "6" the second style line chart is still wrong.

Date	Type	Value
1	Blue	1
2	Blue	2
3	Blue	3
4	Blue	2
5	Blue	5
6	Blue	3
1	Red	2
2	Red	5
3	Red	3
4	Red	1
5	Red	0
6	Red	0

I have to do this to bet the real thing but it seems awfully far fetched

e	Type	Value
1	Blue	1
2	Blue	2
3	Blue	3
4	Blue	2
5	Blue	5
6	Blue	3
1	Red	2
2	Red	5
3	Red	3
4	Red	1
5	Red	0.00001
6	Red	0.00001

Re: Bug in line chart?

Tue, 22 Apr 2014 19:22:24 GMT

Looks like others have experienced this too.

Line chart (stacked area's as Style) - empty (no-data) area is filled up

Re: Bug in line chart?

Chris_Rice — Tue, 22 Apr 2014 21:05:19 GMT

I will agree with that, you should open a case with QlikView Support:

Support@QlikView.com

Re: Bug in line chart?

its_anandrjs — Tue, 22 Apr 2014 21:08:17 GMT

Yes you are right it looks different for the Red values i notice this in another chart thanks for understanding.

Re: Bug in line chart?

andy — Fri, 08 May 2015 15:22:15 GMT

Reported as a bug and accepted in this thread

Help with line chart,please