How to create a Stacked bar chart with 1 dimension and 4 expressions

[Anonymous]

Hi,

I need help creating the below bar chart

3 bars : Blue - US sales for 2013,2014,2015; Gray - Europe sales for 2013,2014,2015; Stacked based on the year.

1 bar:  For 2015,US outlook(in blue) and Europe outlook(in gray) are stacked.

I have Year as dimension and 4 expressions 1 for US sales, 1 for Europe Sales, 1 for US outlook and 1 for Europe outlook.

Can someone help me create this bar chart asap.

Thanks!

[Chanty4u]

hi,

https://community.qlik.com/message/918299#918299

plz chk abve link might helpul somewat

[Anonymous]

Check the attachemnt...

Take Year as Dim and write your 4 expression...

then Properties -> Style -> Subtype -> Stacked..

[jagan]

HI,

Select Stacked option in

Chart Properties -> Style -> Stacked option.

Regards,

Jagan.

[#5]

Hi Add the dimension and 4 expressions then Select the Stacked option in the Style tab Chart Properties -> Style -> Stacked option. Regards Deepak

[Anonymous]

Hi,

Attached a sample qvw file which satisfies your request.

Hope this will help you.

Regards,

Leni Balakrishnan

[Kushal_Chawda]

Please provide the sample data

[HirisH_V7]

Hi,

Check this,

Here:

Dimension:

Month

Expressions:

2013 Sales - Expression Back Ground Color- light Blue()

2014 Sales - Expression Back Ground Color- DarkGray()

Total Sales

Total/2 Sales

Make In Expression Axes For one Axes -> Position -> Right(Top)

Do Check this App,

PFA,

-Hirish

[Anonymous]

Attached my qvw, please take a look a suggest me what needs to be done.

Thanks!

[shree909]

HI,

See the attached qvw .