loading data from excel report to qlikview

[anat]

Hi,

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

please find the attached sample report.

[sudeepkm]

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.

[#3]

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