topic Re: How to load multiple headers from a crosstable into QV in QlikView

How to load multiple headers from a crosstable into QV

Wed, 25 Nov 2020 16:16:04 GMT

Hie Experts

I'm new to Qlikview, I'm having problems trying to load a cross-table into Qlikview and my file is an excel file. The file has three header columns and also dates on top.I have uploaded the file above, if you can show me how to do it, and also is there a smart way to handle dates in Qlikview.

You can post the script for me,because I'm using a personal edition Qlikview so I wont be able to open qvw.

Re: How to load multiple headers from a crosstable into QV

Anil_Babu_Samineni — Fri, 16 Sep 2016 16:56:27 GMT

You want to show same thing in qlikview.

Re: How to load multiple headers from a crosstable into QV

Fri, 16 Sep 2016 17:14:45 GMT

I think this link (Loading Cross Tables) will give you what you need. It is a video on loading crosstables.

Also, here is the script as this link has a qvw that you will not be able to load.

CrossTable(Quarter, Sales)
LOAD [Sales Rep],
[Q1 2010],
[Q2 2010],
[Q3 2010],
[Q4 2010],
[Q1 2011],
[Q2 2011],
[Q3 2011],
[Q4 2011],
[Q1 2012],
[Q2 2012],
[Q3 2012],
[Q4 2012]
FROM
[Data.xlsx]
(ooxml, embedded labels, table is Sheet1, filters(
Remove(Row, RowCnd(CellValue, 1, StrCnd(contain, 'Total'))),
Replace(1, top, StrCnd(null))
));

Here are the results in the qvw:

Hope this works for you!

- Stan

Re: How to load multiple headers from a crosstable into QV

Sat, 17 Sep 2016 08:45:52 GMT

Hi Anil babu,sorry for the late response,Yes i want to show the same thing in Qlikview.

Re: How to load multiple headers from a crosstable into QV

Sat, 17 Sep 2016 08:47:59 GMT

Hi Stan Bennett

Thank you for the link to the video,but thats not what Im looking for,because the excel file has three headers whereas the video i just showing the basic with one header column

Re: How to load multiple headers from a crosstable into QV

Frank_Hartmann — Sat, 17 Sep 2016 09:45:12 GMT

have a look here:

multi_header_pivot_import.qvw

hope this helps!

Re: How to load multiple headers from a crosstable into QV

Anonymous — Sat, 08 Jul 2017 06:49:42 GMT

can you please post the sample data and script from this QVW.

Re: How to load multiple headers from a crosstable into QV

Frank_Hartmann — Sat, 08 Jul 2017 07:14:14 GMT

inside the zip file you will find a qvs (scriptfile )file which you can use in your qvw.

or you open this file with an editor and paste the content to your script.

hope this helps

Re: How to load multiple headers from a crosstable into QV

Nox — Sun, 09 Feb 2020 15:53:41 GMT

Did you find a solution to load a multi header excel file ?