Last week one of our clients asked me to provide a method that they could use to export all of the data from within a QlikView document. They had hundreds of archived documents and they wanted to be able to export the data and use it in another application.
2. Copy the QlikView .qvw document file into your folder. This will make sure you don't accidently update the original document.
3. Double-click on the .qvw file to start up QlikView.
4. From the menu, select File->Edit Script. This opens up the Loadscript Edit Window.
5. At the very top of the loadscript, before the first line, copy and paste in these lines:
/* Export all QlikView tables to tab-delimited files */
if IsPartialReload() then
for ix= 0 to 100
if len('$(tn)')<1 then
Store "$(tn)" into "EXPORTED_QV_$(tn).TXT" (txt, delimiter is "\t");
6. Close the Loadscript Edit Window by clicking the OK button in the lower right corner of the window.
7. From the menu, select File->Partial Reload
If everything works correctly, each of the QlikView tables will be written out as tab-delimited text files into the folder. For example, if the QlikView document contains a QlikView table named HISTCUST then it would write out a text file named, EXPORTED_QV_HISTCUST.txt. The first record will contain the field names.
Note the syntax for specifying the delimiter character. If your Store command simply includes (txt) without specifying the delimiter you will get comma-delimited text files. Use the file specification, (qvd), to get QlikView QVD files.