topic Line Chart issues Q9 SR6 in QlikView

Line Chart issues Q9 SR6

Thu, 18 Nov 2010 15:01:11 GMT

Hi Expert,

I have a Line graph chart with positive and negative values.There is a problem in line chart the negative values are ovelapping with the positive values. So very difficult to find what are the values are belongs to positive and what are the values are belongs to negative.

I heard its a kind of bug in Q9 SR6, could you pls confirm on the same.

Thanks,

Line Chart issues Q9 SR6

johnw — Fri, 19 Nov 2010 01:33:24 GMT

No idea what you're saying. I don't remember seeing anything like this. A quick line chart that I threw together with negative values displays just like I would expect. Perhaps you could post an example of the problem you're seeing?

Line Chart issues Q9 SR6

Fri, 19 Nov 2010 07:56:24 GMT

Hi John,

I hope attached example will have more clear what I am facing the issues in Line chart.

Pls have a look attached screenshot taken from both the versions and had mention my problem in the screenshot itself.

Pls let me know if my question is not clear.

Thanks,

Line Chart issues Q9 SR6

Fri, 19 Nov 2010 08:05:58 GMT

Here I am attaching the qvw file .

Thanks,

Line Chart issues Q9 SR6

prieper — Fri, 19 Nov 2010 10:37:17 GMT

See this point, what what would you expect to display if "Open" would have the value +1 or +2 for 200903?

Usually I do not display figures within a graph, but allow to toggle from line-graph to straight-table.

HTH
Peter

Line Chart issues Q9 SR6

Fri, 19 Nov 2010 10:56:05 GMT

Peter, its our requirement to display the figures in the charts.

Thanks,

Line Chart issues Q9 SR6

prieper — Fri, 19 Nov 2010 11:02:34 GMT

You may display the values above the axis, an idea you may find in the attachment. This might further be pimped with a legend etc, but just to get the idea.

HTH
Peter

Line Chart issues Q9 SR6

Fri, 19 Nov 2010 11:54:42 GMT

No Peter not suggestable...

Thanks,

Line Chart issues Q9 SR6

Fri, 19 Nov 2010 14:57:50 GMT

Hi Experts,

Has anyone come across the Line Chart issues??

Thanks,

Line Chart issues Q9 SR6

johnw — Fri, 19 Nov 2010 19:21:25 GMT

Ah, so your issue is that QlikView puts numbers on top of each other in the chart, making them very hard to read? Yeah, I've seen that before, it's annoying, and I don't know of a workaround. It doesn't really have anything to do with positive vs. negative numbers since you can get the same problem with any lines that are close to each other.

Line Chart issues Q9 SR6

Anonymous — Fri, 19 Nov 2010 19:34:20 GMT

In a similar situation, I advised to use bar chart instead of line chart.

Line Chart issues Q9 SR6

Sun, 21 Nov 2010 11:37:55 GMT

No Michael, as per our requirement it should be in Line chart.

Thanks,

Line Chart issues Q9 SR6

Anonymous — Sun, 21 Nov 2010 14:55:05 GMT

There is no reliable way to prevent overlapping when you have multiple lines with the numbers on data points. The possible approaches I can think of:
- do not show numbers on lines if there is more than one line
- use different type of chart with numbers (table, bar)
- if you have always exactly two lines, split axes.

As for the requirements - they should reflect business needs, and don't create situation where a minor nuance of visual presentation requires inadequate efforts to implement.

Line Chart issues Q9 SR6

Mon, 22 Nov 2010 07:13:34 GMT

Hi,

Could you pls send screenshot of the same in version 10.

Just wanted to make sure that how it look in Q10.

Thanks,

Line Chart issues Q9 SR6

Mon, 22 Nov 2010 08:50:53 GMT

You're lucky, QV 10 by default looks different but ok.

You could use set analysis from version 8.50 upwards


=Count( {$<Status={'Closed'}>} Status)

-Alex

Line Chart issues Q9 SR6

Mon, 22 Nov 2010 09:11:52 GMT

Alex,

Will it be possible to show the values like what is there in 8.2 (Pls refer my screenshots)?

Assume that I am business user I am confusing about the chart.

Because the positive values are belongs to Red line or Green line. As per the graph, it says negative values belongs to Green and Positive values belongs to Red which is quite opposite.

Thanks,