Chart with multiple dimensions axis

[#1]

I want to create a bar chart with tree dimensions in it (age is also a dimension). As you can see in the example, there are different kind of groups. Spicies, Fruit and Vegetables are in the dimension level1, their products are in the dimension level2

When I create this chart in Qlikview, all the products are shown in spicies, vegetables and fruit. Does anybody know how to create this chart without having all the products at each different group? Thanks!

[#2]

Hi William!

can you post an extract of your database, or a simplified qlik doc?

I'd like to see data normalization in order to give you a valid response...

Tanks a lot

Roberta

[johnw]

Boy, I really would have thought it was "suppress zero values" on the presentation tab. It works correctly on a straight table, but not on a bar chart. Strange.

[#4]

ah yes, I was going to post a "how to make a qv chart look like a tableau chart" topic a few days ago but I feared getting banned from posting.