Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
jonnaamb
Contributor III
Contributor III

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

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.

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

jonnaamb
Contributor III
Contributor III
Author

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

Ambareesh J.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

jonnaamb
Contributor III
Contributor III
Author

Thank you Rob.