topic loading data from excel report to qlikview in QlikView

loading data from excel report to qlikview

anat — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

please find the attached sample report.

Re: loading data from excel report to qlikview

sudeepkm — Thu, 04 Aug 2016 12:42:50 GMT

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.

Re: loading data from excel report to qlikview

Thu, 04 Aug 2016 18:06:21 GMT

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