Stacked Bar Graph with Segmentation and ordered per month year

[MikeHerb]

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:

And this for segments:

I want to stack the segments on the bar chart. 

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

Anyone can help?

[Lisa_P · Accepted solution]

If this is what you are trying to do ..

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]

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

[MikeHerb]

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? 

[Lisa_P]

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]

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.