How to this excelsheet into Qlikview

[sreeni_qvd]

Hi All,

Please help me how to load this data excel file into Qlikview. I need meaning full data with fieldnames.

Regards:

Sreeni.

[ThornOfCrowns]

Tidy the file, remove blank rows, put info on separate tabs, then investigate Cross table functionality:

Loading Cross Tables

[sreeni_qvd]

Hi James,

Thank you, but how to do for this excel, give me the cross table code for excel sheet. 

Regards:

Sreeni

[#4]

Find attached qvw.

I have modified your excel little bit. I hope it helps you.

Thanks

Khushboo

[sreeni_qvd]

Yes,

thank you

I did, using transpose option in Qlikview.

Regards:

Sreeni