Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

multi_header_pivot_import.qvw

Gysbert_Wassenaar

multi_header_pivot_import.qvw

This example qlikview document can help you load excel files that contain a pivot table with multiple horizontal headers (dimensions) like in the image below:

multi_header_pivot.png

The instructions on how to use this documents can be found in the script. Basically you set a few variables for the source file name, sheet (table) and type of excel file. And in the HDims and VDims tables you specify the field names of the dimensions. After reload you should then have a table called ResultTable with the data from the excel file.

edit: script now included as a separate file in the zip file

Labels (2)
Attachments
Comments
Not applicable

Kun je het script ook in pdf toevoegen?

0 Likes
Not applicable

Hi Gysbert,,

would I be able to calculate the difference between cat 2 value 1, and Cat 1 Value 4?

0 Likes
Gysbert_Wassenaar

Yes

0 Likes
Not applicable

Thanks Gysbert. do you maybe have a sample that I can look at on how to do it. I think it might be the solution to my discussion that I had loaded earlier today ' Claculating net working days'

Thanks.

0 Likes
robert_mika
Master III
Master III

Could anyone post script from this file ,please?

0 Likes
Gysbert_Wassenaar

Yes and no. I can't add another file. So I created a zip file with the .qvw file and separate .qvs file that contains the script code.

robert_mika
Master III
Master III

Thank you.

0 Likes
selcukcadir
Creator II
Creator II

Good DocumentThanks Gysbert. add your excel file pivotimporttest.xls please.

ahbzshk07
Contributor III
Contributor III

Worth knowing... Thanks (y)

0 Likes
Not applicable

Great stuff gwassenaar‌ . I managed to wrap your code in mulitple loops to take up multiple files and multiple sheets within. Thanks

0 Likes
Version history
Last update:
‎2013-08-20 02:34 PM
Updated by: