How to Unpivot Multi Header table to a flat table

[Anonymous]

Hi Guys, Please assist me with the below.

I am trying to load a multi header table from excel and would like to be able to display it as a straight table in QlikView.

Would really appreciate all the help I can get. (Please refer to the attached file)

Thank you all in advance

[arvind_patil · Accepted solution]

Hi Sello,

Firstly You need to concatenate Two Columns in excel:

Aug 2014Qty

Aug 2014Turnover

Dec 2014Qty

Dec 2014Turnover

Jul 2014Qty

Jul 2014Turnover

Jun 2014Qty

Jun 2014Turnover

Nov 2014Qty

Nov 2014Turnover

Oct 2014Qty

Oct 2014Turnover

Sep 2014Qty

Sep 2014Turnover

After word you get table in excel like this:

Then Convert it into cross table in qlikview .

add caluculate reports

Thanks,

Arvidn Patil

[Anonymous]

Thanks for the reply Arvind, I believe that this could work!

But what if I am dealing with different years and I do not want to hard-code the year?