topic Re: Stacked Bar Graph with Segmentation and ordered per month year in QlikView

Stacked Bar Graph with Segmentation and ordered per month year

MikeHerb — Thu, 04 Mar 2021 03:36:35 GMT

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?

Re: Stacked Bar Graph with Segmentation and ordered per month year

Lisa_P — Thu, 04 Mar 2021 05:10:07 GMT

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.

Re: Stacked Bar Graph with Segmentation and ordered per month year

MikeHerb — Thu, 04 Mar 2021 06:46:15 GMT

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

Re: Stacked Bar Graph with Segmentation and ordered per month year

MikeHerb — Thu, 04 Mar 2021 08:51:50 GMT

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?

Re: Stacked Bar Graph with Segmentation and ordered per month year

Lisa_P — Mon, 08 Mar 2021 04:36:18 GMT

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

Re: Stacked Bar Graph with Segmentation and ordered per month year

MikeHerb — Mon, 08 Mar 2021 08:44:29 GMT

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.