Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Read values from QVW into Excel

I have created QVW document and now want to connect it to the existing management report pack in Excel. It is currently linked to TM1 and feeds data from it via DBRW formulas. I want to relink it to QV. I think I have two alternatives - export data from QVW to the reporting pack, say into auxiliary worksheets and then link into existing report templates or somehow write formula/VBA code that will return the value from QVW. I want to follow the second option and just don't how to approach the issue. I would appreciate simple guidance or advice in simple terms, may be like this:

1. Create excel

2. Open VBA editor

3. ...

4. 

I managed to find sample xls which reads all variables from QVW by Tim Benoit and not sure if it is possible to modify to return set analysis results.

Thanks beforehand.

2 Replies
Not applicable
Author

try sending results to excel (csv)

http://community.qlik.com/message/143215#143215

Not applicable
Author

Doesn't help that much, the text file became bigger than QVD by 40 times and doesn't load into Excel in full (more than 5 mio records). It would be nice to have a piece of code that can pull just one value from QVD. I looked at Nprinting and vizubi, but the problem is I can't install other software.