There are a lot of concepts with Qlikview that can be baffling at first. I really miss being able to purchase a Qlikview ‘Bible’ (and am surprised no one has written one yet). This means you have to learn things by trial and error.
So I’m going to ruminate and exfoliate and some things I have come across. Maybe others will be able to help clarify my thinking about ‘why’ some things happen.
LOAD * INLINE [
First, let’s make a simple chart. Let’s show the names of the Sales Person and what area they are associated with.
That’s fairly easy, create a straight chart, add Name as the Dimension, and Area as the expression.
You will notice the nice dash at the top, this is because it is trying to total the rows. So open up the Expressions tab and click No Totals in the Total Mode. And the dash will go away.
Ok, the challenge, reverse the display of the data. Show the areas that the Sales Person is associated with. Like this (once again straight chart, pivots are a whole different animal)
Now of course your initial thought is probably to set Area as your dimension, and Name as your expression. Like
But if you do that you will end up with
Now that’s pretty strange isn’t it 🙂