topic Read values from QVW into Excel in QlikView

Read values from QVW into Excel

Mon, 26 Jan 2026 16:26:21 GMT

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. ...

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.

Read values from QVW into Excel

Thu, 06 Oct 2011 10:05:16 GMT

try sending results to excel (csv)

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

Read values from QVW into Excel

Fri, 07 Oct 2011 08:52:52 GMT

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.