If the user could be capable to choose why dimension, or why combinations of dimensions he would like to see maybe it's be useful.
I'm afraid not understand the dimension of your problem, but, look the example app "Expense Management" in Qlikview "Getting Started", the sheet Report there a sample. I like to use that's kind of alternative when are more dimensions than space.
of course if the user would just tell me what is more important to him/her, I could just code it that way and it would be easier.
<=> However, I would like to not force the user to make that choice, but instead enable them to see whatever combination of dimensions they want.
Actually, it's only two dimensions where this issue arises because two are decided beforehand:
- The dimension "day" (or later "month") must always be there.
- The columns for the early and the late shift of every day should always be visible side by side
=> That narrows the choice I want to give the user down to the dimensions gate_ID and lorry/container.
Perhaps this document gives you inspiration: Customisable Straight (and Pivot) Tables - more food for thought. Don't let the title mislead you. The same technique can be used for other chart types too. Of course other charts can deal only with a limited number of dimensions.