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, 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:

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!

0 Replies