Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kolakiran
Contributor II
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

8 Replies
kkkumar82
Specialist III
Specialist III

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
Master
Master

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

Hi ,

Qliksense

joshabbott
Creator III
Creator III

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

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
Creator
Creator

Hi @simonpinnow  and @kolakiran 

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

Thanks.

simonpinnow
Contributor II
Contributor II

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
Partner
Partner

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?