Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

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.

View solution in original post

5 Replies
JonnyPoole
Employee
Employee

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.

rubenmarin

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
Author

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?

asanoop24
Contributor
Contributor

Do you happen to have any idea if Qlik has included this functionality in their latest versions as this has been a pending problem for more than 3 years now?

robert99
Specialist III
Specialist III

No. Its still (it seems) 2 dimensions and 1 measure

Or 1 dimension and one or more measures

What I would most likely do for this is use a drill down dimension and 4 measures (Q1 Q2 Q3Q 4)

Or look for a extension option