topic Combo chart issue in QlikView

Combo chart issue

Tue, 06 Sep 2011 14:19:42 GMT

Hi,

I want to create a Combo chart in which I have Fruits as a Dimension, with 2 expressions. -

One with an Average of just the selected from the Listbox1 on the left and another expression (Average) of the Fruits selected on the right(Listbox2)

The expression relating to the selection of Fruits on the left must show as a Line and the other one(Fruit1) must be shown as a Bar.

All of this seems to be fine, but instead of just showing a dot when I select one Fruit from Listbox1, I want to show a line. (As if I'm selecting more than 1)

Is this possible, or perhaps another way to achieve this?

Much appreciated!

Combo chart issue

Tue, 06 Sep 2011 14:31:52 GMT

Your question isn't clear -- could you draw a picture of what you want to achieve?

In your example you have one dimension for both series -- QlikView behaves correctly when draws only one point (dot) for 1 dimension value selected.

Combo chart issue

Tue, 06 Sep 2011 15:54:16 GMT

Thanks for your response.

I understand that Qlikview is doing this correctly, as 1 fruit would logically = 1 dot(not a continuous line). BUT

I was wondering if there is possibly another way of creating the line so that it looks more like a trend line~(longer). -

As if I were to select more than 1 fruit from Listbox 1.

Not sure if it is possible?

Combo chart issue

Tue, 06 Sep 2011 15:59:19 GMT

saffatwist,

Still can't imagine how do you want dimension values to be shown in your case.

Coulple of ideas to try:

1) use reference lines (can be defined in tab Presentation)

2) use 2 charts put one over another (background of top chart should be transparent)