Bar chart with grouped bars behind each other

[alec1982]

Hi guys,

I am trying to replicate the chart in my excel attachment with no luck..

Can you please help me..

Best,

Alec

[tresesco]

Bar chart-> Style tab: last 'Look'.

[alec1982]

Hi,

Thank you for the quick reply but that doesn't work. see attached the qvw.

[tresesco]

It actually depends on number of dimensions/expressions you use in your chart.

[alec1982]

Thank you again for the information but that doesn't help me..

[alec1982]

I am still not able to find a solution to replicate the chart I have attached on my post..and would appreciate any help or suggestion.

[jagan]

Hi,

I think this chart is not possible in Qlikview, the best chart for this is the Line chart you can see the flow of the values clearly.

Regards,

Jagan.

[r_wroblewski]

Hi Alec

you need to restructure your data.

Please see screenshot & check attached qvw-file.

Let me know when you have questions.

Best regards,

Ronny

PS: Maybe you can use File Wizard (Transform) to restructure the data.

[alec1982]

Hi,

Thank you for your help.. this works if I can modify my data but I cannot, the expressions to calculate PY Mar, PY Rev and PY Quota have set analysis in them and I am afraid I will not be able to change the structure..

Any thoughts?

best,

Alec

[jagan]

Hi Alec,

Please check attached file for solution.  Hope it helps you.

Regards,

jagan.