How to achieve the following by using a Bar Chart?

[shannoypaul]

Dimension1: Month

Dimension2: City

Fact1: Forecast

Fact2: Budget

Fact3: Actual

[vikasmahajan]

Hello

Create dummy data in excel and attach so that anybody can help you.

Vikas

[agilos_mla]

Hi  it's not possible to achiveve this layout, when using multiple expressions with at least two dimensions the bar chart turns automatically into stacked bar.

Look at this post.

http://community.qlik.com/thread/103307

A way to achieve sthg very similiar is to create a calculated dimension by concatening the strings City-Month, then you'll have one single dimension, the tricky thing is how to define a correct sort order. (simplest way is in the script)

Michael.

[Clever_Anjos · Accepted solution]

An workaround

[shannoypaul]

Thank You!

[shannoypaul]

Thank You!