3 Replies Latest reply: Mar 12, 2012 3:26 PM by Karl Pover RSS

    Selecting a limited amount of rows in Excel as table

      I have a excel table which is autmatically generated out of another tool. This tool generates two tables of data in the same sheet, the first one with absolute figures, the second one with relative.

       

      I want to use the set of rows containing the absolute data as a table in qlikview. How do I do this.

       

      E.g.: I want to use rows 9 to 500 from the sheete, but not 1 -> 8 and everything above 500.

       

      Can this be done ?

       

      Thanks in advance !