topic Re: Line chart problem in QlikView

Line chart problem

Thu, 21 Jul 2011 15:26:36 GMT

hello,

I have a problem when creating a line chart.

I am using 2 dimensions. On X, I have something like 1,2,3,4,5,6,7,8,9 and on Y, I have 100,99,55,44,11,0,77,5,100.

Thus 1 corresponding to 100, 2 to 99 etc...

But QlikView don't draw the line passing by each point. What I have is the first plot (1,100) linked to the last (9,100).

Why don't the line pass by the plot between them?

I try some change like this X=1,2,3,4,5,6,7,8,9 and on Y=100,99,55,44,11,0,77,5,10.

And oh, miracle, the line pass by all plot.

Other change X=1,2,3,4,5,6,7,8,9 and on Y=100,99,55,55,11,0,77,5,100.

Well, in this situation, (1,100) and (9,100) are linked, (3,55) and (4,55) are linked too.

I conclude that it link all with the same Y value.

But, it don't change the question, how do I make the line pass by all the plot? and not to draw line between plot with the same Y value?

Thanks for your help.

Thu, 21 Jul 2011 15:52:57 GMT

Can you share a sample chart or more details ?

swuehl — Thu, 21 Jul 2011 16:18:58 GMT

Hi,

you said you used 2 dimensions. What is the second one?

It seems that QlikView has some special issues with line charts and multiple dimensions.

With the data you gave above and using 1 dimension X, expression = Y, I couldn't reproduce your problem.

Stefan

swuehl — Thu, 21 Jul 2011 16:20:13 GMT

For clarity, here is my sample

Stefan

Fri, 22 Jul 2011 07:40:07 GMT

Hi, thanks for your example, it help me.

Well, I delete one of the dimension and oh miracle, I got what I want.

Thanks again.