Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sreeni_qvd
Creator
Creator

How to this excelsheet into Qlikview

Hi All,

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


Regards:

Sreeni.

4 Replies
ThornOfCrowns
Specialist II
Specialist II

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

Loading Cross Tables

sreeni_qvd
Creator
Creator
Author

Hi James,

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

Regards:

Sreeni

Not applicable

Find attached qvw.

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

Thanks

Khushboo

sreeni_qvd
Creator
Creator
Author

Yes,

thank you

I did, using transpose option in Qlikview.

Regards:

Sreeni