Ok, but what happens if I have something like a table with BusinessUnits and OrderNumbers...
so I think BusinessUnit could be my Dimension, because I want to know which OrderNumbers belong to my BusinessUnits, so I can filter for BusinessUnits.
But now, I have several OrderNumbers for just one BusinessUnit... in this case QV dont show me any value.
Do u know what I did wrong?!
well, you can do different things in QlikView, of course.
But in that specific instance - when you have several values that should be displayed on the same dimension_point, QlikView doesn't display them in charts - only in listboxes - so you need to have a second dimension that makes this unique, so you have only one OrderNumber per dimension_point - the easiest unique dimension is a rowNo(). You can just set that field to not be displayed.
yes, dimensions and expressions are just like you learned in math. You have a dimension along the x-axis (horizontally) and an expression on the y-axis (vertical) - usually. There is an option to turn that around in QlikView so that you can make a barchart (which normally has vertical bars) go horizontally. That way, you can have a chart that has horizontal bars going to the right and to the left off a line in the middle of the screen.
The usual case, though, is the regular understanding of dimension vs expression.
For ex., you want to chart "sales volume per sales_person" - so the sales_persons (their names or IDs) will be your dimension and your expression will be sth like the sum of their respective sales figures.