I have an Excel file to load my data from that is actually a crosstable - so the correct way would be to load it as a crosstable which gives me three fields - two for the dimensions and one for the data.
So far no problem.
How can I create the same thing again in QlikView now (a crosstable)? When I select the diagram type "straight table", I have the option of ticking a checkbox "horizontal" on the presentation tab, but then all my dimensions will be horizontal which is not what I want. One dimension should remain vertical, the other should be horizontal.
Thanks a lot!