topic How to Unpivot Multi Header table to a flat table in QlikView

How to Unpivot Multi Header table to a flat table

Anonymous — Fri, 03 Nov 2017 09:42:55 GMT

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 — Fri, 03 Nov 2017 11:49:32 GMT

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 — Fri, 03 Nov 2017 12:05:01 GMT

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?