topic Re: QMC data into .xls (excel) format, is this possible? in QlikView

QMC data into .xls (excel) format, is this possible?

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

Hello experts,

I have a requirement to get information from QMC about all the names of the tasks, their dependent tasks, individual average duration, their qvw file, scheduled/dependant, etc. in an Excel format (.xls). Do I need to prepare this manually or is there a shortcut for this ? Please guide.

Ambareesh J.

Re: QMC data into .xls (excel) format, is this possible?

rwunderlich — Wed, 09 Nov 2016 15:42:50 GMT

You can use this tool:

Qlikview Cookbook: QVPR Analysis http://qlikviewcookbook.com/recipes/download-info/qvpr-analysis/

to load the QVPR database into QlikView. From there you can make a chart with the fields you want and export it. You could also modify the script to export data in the format you want.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: QMC data into .xls (excel) format, is this possible?

jonnaamb — Wed, 09 Nov 2016 15:56:04 GMT

Is there any alternative to this ? What if we are working in the client system and cannot install any freeware/software ?

Ambareesh J.

Re: QMC data into .xls (excel) format, is this possible?

rwunderlich — Wed, 09 Nov 2016 21:24:25 GMT

The QVPR-Analysis tool does not require any installation. It's just a QVW that you reload. You only need access to the QVPR folder. Alternatively, you can copy of the QVPR folder (or one of the zip backups) to a temp folder on your own machine and reload from there.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: QMC data into .xls (excel) format, is this possible?

jonnaamb — Thu, 10 Nov 2016 20:23:14 GMT

Thank you Rob.