Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.