Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
BasC
Contributor II
Contributor II

3 dimensions, 1 measure in bar chart - group 2 dimensions

Hi,sorry for the double post. I posted this in a different subforum earlier but got 0 replies, so I'd like to try again.


I want to make a bar chart with 3 dimensions and 1 measure. Just like this, but this is Qlik View:
https://stackoverflow.com/questions/35844694/qlikview-displaying-charts-in-grouped-style/35869995#35...

So I have 3 dimensions:
- Year-Month (x-axis)
- Barge or truck
- Location

1 measure:
- Count(distinct container) (y-axis)

In the attached screenshots you can see both dimensions in a separate bar charts. In the 2nd screenshot you can see an attempt where I tried to combine dimension 2 and 3 into 1 dimension, but it looks shoddy. I'd like the months to be combined (the bar charts (locations) next to each other with space to the next month).

So I'd like it like this, basically:

BasC_3-1626080654757.png

Where the year would be the month in my chart, region the location in my chart and quarter the barge or truck dimension and sum(LineSalesAmount) would be count(distinct container). Surely this must be possible in Qlik Sense?

Thank you in advance!

3 Replies
MayilVahanan

Hi 

Based on Help, its not possible to include 3 dimension in bar chart in Qliksense.

Refer: https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Visualizations/Bar-Chart/...

 

MayilVahanan_0-1626084213382.png

 

Might be, you can try with alternative dimension

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
BasC
Contributor II
Contributor II
Author

Ah, thank you. That's a shame though. Seems odd to me, an option that is available in Qlik View not being available in Qlik Sense.

MayilVahanan

Hi

You can raise a idea for this.

https://community.qlik.com/t5/Suggest-an-Idea/idb-p/qlik-ideas

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.