multi_header_pivot_import.qvw

    This example qlikview document can help you load excel files that contain a pivot table with multiple horizontal headers (dimensions) like in the image below:

    multi_header_pivot.png

    The instructions on how to use this documents can be found in the script. Basically you set a few variables for the source file name, sheet (table) and type of excel file. And in the HDims and VDims tables you specify the field names of the dimensions. After reload you should then have a table called ResultTable with the data from the excel file.

     

    edit: script now included as a separate file in the zip file