how to show 3 dimensions on x-axis in barchart ? As shown below

[Anonymous]

Hi Experts,

How to show 3 dimensions on x-axis in barchart ? As shown below

need to calculate Quarter,Year, and item type.

Thanks in advance

Kiran

[kkkumar82]

You may not get the X axis look but you may get like Year in X axis and Quarter1,.... Quarter4  as Legends, is this in

Qliksense or QlikView ?

[rittermd]

You are limited to 2 Dimensions in a bar chart.  You can add alternative dimensions which might help you out.

You may need to concatenate the year and Qtr together (Q1-2015, etc.). 

Are the 3 bars the months in the quarter or are they the Item types?

I doubt that you will get the exact look you have displayed.  But you can come up with something that will work.

[Anonymous]

Hi ,

Qliksense

[joshabbott]

I just had this issue and found a solution that worked for me:

1 - Create your bar chart with the 3 dimensions and 1 measure

2 - Make sure your most outward dimension (if you are doing year/month/week, it would be year) is listed first.

3 - On the 'Dimensions' page, click the 'Trellis' button.

4 - If you have a fixed number of years (or first dimensions) this will work best, but now check 'Enable Trellis Chart', then for number of columns, select your fixed number, and number of rows, select 1. 

Hope this helps!

[simonpinnow]

Hi Josh,

which Version of Qlik Sense are you using? We are using Qlik Sense 11.24.5 and I can only add 2 dimensions to a bar chart and the the button is greyed out...

And what do you mean with "dimensions page"? Do you mean the dimension section in the properties of the bar Chart?

Thanks for helping!

Best regards

Simon

[ritaaguiar]

Hi @simonpinnow  and @Anonymous 

Did you manage to do a bar chart with three dimensions in Qlik Sense? I have the same issue.

Thanks.

[simonpinnow]

Hi @ritaaguiar,

yes I do. I wanted to do the same as shown in the screenshot of the article. But I didn't get it working.

Best regards

Simon

[DanielPanche]

Where did you find that 'Trellis' buton?

And how i create the bar chart with the 3 dimensions and 1 measure in the first place?