Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
timml_hsu
Contributor III
Contributor III

Combo Box (Stacked bar & line) vs Excel

Hi, All

We have a data & excel create a chart like below:

Excel sample.png

the same data, using qlikview we can create a chart as below, but the line is different:

QV sample.png

how could I fix this?

2 Replies
timml_hsu
Contributor III
Contributor III
Author

Hi,

does anyone have solution? or explain it?

thanks a lot

marcus_sommer

I'm not absolutely sure but I think you touched the max. amount of dimensions and expressions which are possible with a stacked combo-chart. I think your line isn't really a line against the dimensions else just a single value - if you changed the type from line to point it should be clearer.

An alternatively might be to concat the two dimensions (in datamodel or in the chart - just Dim1 & ' - ' & Dim2) or to enable a grid for one dimension (bottom left in tab dimension). Another way would be to use two specialized charts which are on to of eachother (with the apropriate layout-adjustments to the axis, border, title and so on).

- Marcus