Cant create following chart

[#1]

Hi All,

I have following data

Year	Target	Actual
Year 2005	88	67
Year 2006	54	40
Year 2007	67	22
Year 2008	87	25
Year 2009	87	13
Year 2010	57	69
Year 2011	68	31
Year 2012	51	64
Year 2013	91	18

I want to show following kind of chart

how to create this kind of chart in Qlikview.

please help me on this.

[RonaldDoes]

Would this work for you?

[Sergey_Shuklin]

Hello, Narendra!

This can be done by two ways:

1. Create two similar charts, make them transparent and lay them on each other;

2. Crete one chart, but with six expressions where each of them will be the 1/6 of the each bar (Year). Some bars will be one colored (blue), some - stacked with two colors (orange + blue).

[Kushal_Chawda]

As all suggested, either you create the two Bar chart charts with variable Cluster distance propeties , one on top of other, make top chart transparent.

or you can slightly change the presentation like below

[Sergey_Shuklin]

If you get interested with the second way - please, take a look at the attachement.