Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

loading data from excel report to qlikview

Hi,

i am migrating excel reports into qlikview.how to load data from excel reports to qlikview.

please find the attached sample report.

2 Replies
Highlighted
Specialist III
Specialist III

I think the ideal way is to load raw data (that generates the Report in excel) into QlikView.

Report is already aggregated data and specific format bound.

If you have a feasibility to load raw data into QlikView then it would be easy to build report in QlikView exactly how it is in excel or even better than that.

Highlighted
Not applicable

Hello ananth,

So as sudeepkm said it is better  to feed QV with raw data. So for my example I extracted it from pivot.

Attaching very simple app for you to check.

PS. If for any reason you are interested to feed pivot itself, I left it commented in qvw code.

BR,

Kuba