Is it possible to remove all data values of a QlikView file automatically (by batch) ?
Hi,
I would like to make a backup of a qvw files folder. For speed and size matters, I would like to save the Qvw Without data.
I'm looking for a way to do it automatically, I mean open all qvw file in a folder, execute a Reduce Date / All Value command, save and close. In the QlikView Reference Manuel, chapter 6.1, I found how to open the file without data (qv.exe /NoData) but I don't know how to save and close the file.
Is anyone know how to do it (maybe without another command or by using the QlikView Server or Publisher ?)
Other option for you to have a variable, say v_back_it_up, and pass it from qv.exe/r command line to set it to "X".
qv.exe /r /vv_back_it_up=X .....
Then in a macro, which is triggered in Document OnOpen, check this variable value and if it is X then reduce all the data and back it up in a VBScript. You can use following in the macro to drop all the data from document:
ActiveDocument.RemoveAllData
After the backup reload will load the data again in the document.
Why don't you save the document in the XML format. With v9.0 QlikView has an option to export the whole document in an XML file and keep it in your code library. Later you can import it to create the same QVW again. Have a look at File -> Export.... menu options.
Other option for you to have a variable, say v_back_it_up, and pass it from qv.exe/r command line to set it to "X".
qv.exe /r /vv_back_it_up=X .....
Then in a macro, which is triggered in Document OnOpen, check this variable value and if it is X then reduce all the data and back it up in a VBScript. You can use following in the macro to drop all the data from document:
ActiveDocument.RemoveAllData
After the backup reload will load the data again in the document.
