Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How to combine stacked and grouped chart together?

Newbie Sense question...I want to combine the two charts below in to one. It should show product as stacked chart but have both Quarter and Category on X axis. Is there a simple way to do this? I have attached the QS file.

Tags (4)
1 Solution

Accepted Solutions
Employee
Employee

Re: How to combine stacked and grouped chart together?

This one isn't possible. The bars are stacked or grouped with a 3rd dimension (to stack and group) not possible at the current time.

You can do 3 dimensions in a tree map but not sure if that helps.

3 Replies
Employee
Employee

Re: How to combine stacked and grouped chart together?

This one isn't possible. The bars are stacked or grouped with a 3rd dimension (to stack and group) not possible at the current time.

You can do 3 dimensions in a tree map but not sure if that helps.

Re: How to combine stacked and grouped chart together?

Hi Manish, if it can work as a workaround you can create a combo chart, adding as bars:

Sum(Units)

Sum({<Product={'Apple'}>} Units)

Sum({<Product={'Bail'}>} Units)

And adding as lines:

Sum({<Category={'BusinessUnit'}>} Units)

Sum({<Category={'Customer'}>} Units)

Sum({<Category={'Sales'}>} Units)

Not applicable

Re: How to combine stacked and grouped chart together?

Hi Ruben -- thanks. I think this is what you meant. I will check if I can make it more visually appealing.

Would Drill Down dimension work here in any way?

Community Browser