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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeHerb
Contributor III
Contributor III

Stacked Bar Graph with Segmentation and ordered per month year

Hi All, 

I am kinda new to Qlik and the bar graph I want is a stacked bar graph showing the split of one of our dimensions which is segments by revenue. what I have now is this for revenue:

Screen Shot 2021-03-04 at 10.25.03.png

 

 

 

And this for segments:

Screen Shot 2021-03-04 at 10.25.19.png

 

 

 

 

 

 

 

 

 

 

 

I want to stack the segments on the bar chart. 

 

I can't seem to figure out on how to. 

 

Anyone can help?

Labels (1)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

If this is what you are trying to do ..

Lisa_P_0-1614834474608.png

All you need to do is add Segment as  a dimension in your bar chart and in the properties of the bar chart under Appearance > Presentation select the Stacked option.

 

View solution in original post

5 Replies
Lisa_P
Employee
Employee

If this is what you are trying to do ..

Lisa_P_0-1614834474608.png

All you need to do is add Segment as  a dimension in your bar chart and in the properties of the bar chart under Appearance > Presentation select the Stacked option.

 

MikeHerb
Contributor III
Contributor III
Author

thank you so much!!! that was so simple I feel a bit stupid!! thank youuu sooo much!!! 

MikeHerb
Contributor III
Contributor III
Author

I have another question with this in the data box that pop up when you mouse over is there a way to include a percentage of that segment? 

Screen Shot 2021-03-04 at 15.51.22.png

Lisa_P
Employee
Employee

Yes, you can add additional tooltips at the bottom of the properties panel under appearance.

Switch from Basic to Custom tooltip.

Add a measure to show percentage of whatever your date dimension is

eg Sum([Revenue USD])/Sum( TOTAL <YearMonth> [Revenue USD])

and format and label as percentage

MikeHerb
Contributor III
Contributor III
Author

I am not sure why I am getting errors and it doesn't say what error it is here is my expression for the data set I have:

 

Sum([RevnueUSD_ExCudeCancel])/Sum( TOTAL <EndOfMnt.YearMonth> [RevnueUSD_ExCudeCancel])

 

Ignore the misspellings that's how the data was sent to me. 

 

Hope you can help.