Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
anat
Contributor

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
sudeepkm
Valued Contributor III

Re: loading data from excel report to qlikview

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.

Not applicable

Re: loading data from excel report to qlikview

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