1 Reply Latest reply: May 2, 2013 4:00 AM by Gysbert Wassenaar RSS

    Simple? How can I create a crosstable in QlikView?

    Friedrich Hofmann

      Hi,

       

      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!

      Best regards,

       

      DataNibbler