Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kolakiran
New Contributor II

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

Hi Experts,

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

need to calculate Quarter,Year, and item type.

Capture.PNG

Thanks in advance

Kiran

5 Replies
kkkumar82
Valued Contributor III

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

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
Honored Contributor

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

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.

kolakiran
New Contributor II

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

Hi ,

Qliksense

joshabbott
Contributor III

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

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
New Contributor II

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

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