Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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!

10 Replies
Chanty4u
MVP
MVP

hi,

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

plz chk abve link might helpul somewat

Anonymous
Not applicable
Author

Check the attachemnt...

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

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

jagan
Partner - Champion III
Partner - Champion III

HI,

Select Stacked option in

Chart Properties -> Style -> Stacked option.

Regards,

Jagan.

Not applicable
Author

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

Anonymous
Not applicable
Author

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
Master
Master

Hi,

Check this,

Stacked Bar with One Dimension And Four.PNG

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

HirisH
“Aspire to Inspire before we Expire!”
Anonymous
Not applicable
Author

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

Thanks!

shree909
Partner - Specialist II
Partner - Specialist II

HI,

See the attached qvw .