topic Re: Crosstable from excel with multiple headerline in QlikView

Crosstable from excel with multiple headerline

Wed, 08 Dec 2010 09:00:50 GMT

I got an excel file with the format as I attach. I have to load that kind of excel file into Qlikview so can be analyzed.

Got headache with that kind of file and need your help [:(]

Re: Crosstable from excel with multiple headerline

Mon, 24 Dec 2012 19:42:03 GMT

Did you ever get a response? I have a similar problem, 2 years later.

How do I write an efficient script that pulls multiple dimensions into a cross table, separately:

Customer ID Region Jan Cost Jan Volume Feb Cost Feb Volume

I'd like to have cost and volume broken out as separate fields. Any advice would be much appreciated.

Right now the only way I can think of is to load the same raw data file twice, and comment out the cost or volume fields in each one. This obviously results in inefficiencies when loading, and a syn-riddled data model.

Re: Crosstable from excel with multiple headerline

Gysbert_Wassenaar — Tue, 25 Dec 2012 16:12:02 GMT

See attached files for an example.

Re: Crosstable from excel with multiple headerline

Sun, 30 Dec 2012 18:22:09 GMT

Thanks! Was hoping for a more elegant solution than this, especially since this problem appears to have been making the rounds on Qlikview forums for some time now. Does anyone have a simpler solution?