Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Importing Excel Pivoted table in Qlik Sense?

Hi Family,

May you kindly assist me with the file attached.

I am trying to import this in Qlik Sense and I battling a bit..Please help.

Thank you in advance

4 Replies
Employee
Employee

Re: Importing Excel Pivoted table in Qlik Sense?

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.

This is not glamorous, and it could be cleaned up a bit, but it works.

Hope this helps.

...PB

shraddha_g
Honored Contributor III

Re: Importing Excel Pivoted table in Qlik Sense?

To directly import any Excel, it has to be in simple table format.

For pivot you will have to modify it to convert in simple table format.

rohitk1609
Valued Contributor II

Re: Importing Excel Pivoted table in Qlik Sense?

Hi Sello,

You may do it by yourself as Create a new app then open app then drag and drop this excel file and it will be get open after that load the data and go to app overview follow up start creating visuals

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Rohit Kumar

chooco_co
Valued Contributor

Re: Importing Excel Pivoted table in Qlik Sense?

Hi Sello,

Qlik Sense 3.1 can unpivoting crosstab data.

Please check this link.

http://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/LoadData/unpivot-crosstable.htm

Regards,

Marco