Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Highlighted
sreeni_qvd
Contributor

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
Valued Contributor II

Re: How to this excelsheet into Qlikview

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

Loading Cross Tables

sreeni_qvd
Contributor

Re: How to this excelsheet into Qlikview

Hi James,

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

Regards:

Sreeni

Not applicable

Re: How to this excelsheet into Qlikview

Find attached qvw.

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

Thanks

Khushboo

sreeni_qvd
Contributor

Re: How to this excelsheet into Qlikview

Yes,

thank you

I did, using transpose option in Qlikview.

Regards:

Sreeni