Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mjamesking
Creator
Creator

Bar chart with more than 2 dimensions - Alternative approaches?

Hi,

I understand that in Sense we cannot have a bar chart with more than two dimensions. I have a requirements whereby we want to show the annual breakdown of things by two different categories, lets call them Primary and Secondary

So we have a dimension of years, grouped bars to show the volume of the Primary dimensions for each year, and then would like to see these bars stacked, to show the volume of each secondary dimension for each primary

Something like:

Example_Chart.PNG

I don't believe this is possible, with us limited to a max of 2 dimensions. Anyone got any suggestions of how to represent the above in a chart, or a number of charts with an alternative approach?

Thanks in advance

Matt

2 Replies
Gysbert_Wassenaar

It looks like you're more interesting in how A-B-C compare against each other then Year on Year comparisons. So you could create a calculated dimension like Year & '-' & Primary to create a single dimension with values like 2016-A, 2016-B, 2016-C, 2017-A etc.

The treemap can use more dimensions, but it may be hard to read. And of course there's always the simple table, or the pivot table.


talk is cheap, supply exceeds demand
mjamesking
Creator
Creator
Author

Thanks for the suggestions - the calculated dimension does work, but it's quite difficult to see where one year ends and another begins, any ideas on that?

Meanwhile, I'll try a treemap and see how that looks.