Loading Cross Tables

    This videos show how to load a cross table in to QlikView.  A cross table has category information along the rows and columns.  QlikView, like most analytical systems needs the data uncrossed to be most effective.

     

    If you are unsure how to load data into QlikView please see:

    Loading ODBC Data into QlikView

    Loading Excel Data into QlikView

     

     

    This is an example of a cross table:

    Sales PersonQ1Q2Q3Q4

    John

    50302010
    Mary30105010

     

    During the load the data will be transformed to this format:

    Sales PersonQuarterSales
    John

    Q1

    50

    Mary

    Q130
    JohnQ230
    MaryQ210
    JohnQ320
    MaryQ350
    JohnQ410
    MaryQ410