Importing Excel Pivoted table in Qlik Sense?

[#1]

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

[pbk]

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]

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]

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

[marcohadiyanto]

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