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: 
anthony-gb
Contributor II
Contributor II

Stacked and Clustered Column

So I am having trouble with visualizing data in a certain way. I'd like to produce something similar to this, except just the actual is stacked.

anthony-gb_0-1615171990990.png

 

I have the following tables

1. The Sales Table- https://prnt.sc/10fqy10

2. The Budget Table which stores the year and the target date, and the connection to the store hierarchy https://prnt.sc/10fr03l 

3/4.  the store and department tables which link the budget to the store/department 

What I am hoping to achieve is the following.

on the X axis, i'd like the Budget Year (eg. 2017/2018)
I would like two columns per year
1. The sum of the Budget Amount for the Year

2. A stacked column of the contract_amount, broken down into stage.

My problem is that when I try to make a stacked chart, it also adds the budgeted amount sum, when I want that in a separate column and just stack the contract_amount. I have made this data up to illustrate the problem in the attached excel file.

Is there some way to achieve this? I would be happy to solve with a paid extension if it makes it easier to produce these, I can do it in Excel.

Labels (3)
2 Replies
tm_burgers
Creator III
Creator III

Unfortunately a stacked and grouped bar chart is not an available visualization. 

 

KL1
Contributor III
Contributor III

please watch the below video: 

https://www.youtube.com/watch?v=KwyqkOt6RJQ