Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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