Import pivot table from Excel into Qlikview

[#1]

Hi Guys,

I am trying to import excels files into Qlikview as below format :

I have tried Crosstable but didn't work.

Any suggestions?

Thanks.

Regards,

Iwan

[#2 · Accepted solution]

Hope this file will help you

[nvijay5757]

Hi this one is working in qlikview. the same scenario in qlik sense not working. in inline load showing error can anyone help me. thanks

[Hoffman14]

Open the Script editor from the File menu or press Control+E. Choose the "Table Files" option from the "Data from Files" tab and browse for the file containing the above data. The following screen appears. Click "OK" and press "Control+R" to load the data into QlikView's memory. Arise Portal Login