Discussion board where members can get started with QlikView.
i am migrating excel reports into qlikview.how to load data from excel reports to qlikview.
please find the attached sample report.
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.
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.