How to combine stacked and grouped chart together?

[#1]

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.

[JonnyPoole · Accepted solution]

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)

[#4]

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]

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]

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