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

    Multiple header from Excel into Qlikview



      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.