topic Import data into Qlik from Excel Power Pivot table in QlikView

Import data into Qlik from Excel Power Pivot table

Thu, 09 Feb 2012 17:10:58 GMT

I have an excel power pivot table that I'm trying to import into QlikView. My pivot table has 2 diminsions. One is a date, the other is a string. I have one Fact which is a performance percentage. Please direct me to a tutorial that shows how to import this type of table from Excel.

Re: Import data into Qlik from Excel Power Pivot table

harvinderjohal — Tue, 14 Feb 2012 16:25:07 GMT

Hi Dave,

I was searching the web and found this "how-to" video on Youtube. In QlikView, loading Excel Pivot Tables is reffered to as a Crosstable. There's more information in the online help on the Crosstable feature, however, the YouTube link at the end of this reply shows how you can use QlikView's wizard to help you load the Pivot Table and help QlikView understand what the structure of the Pivot Table looks like.

Here's the Link: http://youtu.be/qHu45iWamL8

Cheers,

Harvey

Re: Import data into Qlik from Excel Power Pivot table

writetoprithvi — Wed, 01 Apr 2020 08:06:35 GMT

question is different and answer is different. I would like to import power pivot or power bi tables into qliksense as scirpting language in qlik sense is not that easy. I do not think it is possible in qliksense.

Re: Import data into Qlik from Excel Power Pivot table

po22llak — Wed, 01 Apr 2020 12:34:04 GMT

Assuming that you do not want to alter the format of the Excel file at all, attached is an attempt to import and pivot the data provided.

Re: Import data into Qlik from Excel Power Pivot table

writetoprithvi — Thu, 02 Apr 2020 07:44:27 GMT

There is no attachment.