9 Replies Latest reply: Aug 1, 2015 5:48 PM by Wilson Lee RSS

    Multiple header from Excel into Qlikview

    Wilson Lee

      Hello,

       

      I have an excel file where the first Row of the he ! !ader contains the years 2014 and 2015, and right underneath the Years are columns for the Months. I want the Years to somehow to be treated as a column and link to the respective Month.

      2015-08-01 14_27_52.png

       

      I want the table in QlikView will look like this.

      2015-08-01 14_25_45.png

       

      Please tell me how this can be achieved.

       

      Thank you in advance.