Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Remove data from qvw with command line

Hi All,

Does anyone know if there is a way to remove data from a qvw with a command line but by keeping the field names.

I have tried the following...

C:\Program Files\QlikView\qv.exe /nodata C:\Folder\File.qvw

but this removes ALL data including field names which then loses all field formats set in the document properties.

I basically want a way of doing the same thing as FILE>REDUCE DATA>REMOVE ALL VALUES but with a command line instead.

Does anyone know a way?

Thanks


23 Replies
Not applicable

I am getting this message... Active x Component can't create object qliktech qlikview

jhamard
Partner - Contributor III
Partner - Contributor III

Vote for my idea : 😉

alexdataiq
Partner - Creator III
Partner - Creator III

That is a good idea, I will try to implement it myself. I hope I will make it work!

Regards

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Watch out for these solutions having different effects on your QlikView document internals. Two trains of thought in this discussion:

  • DELETE DATA MODEL = this is what you get if you skip the Load script altogether. It also deletes all your fields and related properties (triggers? Always one selected!!!) which is exactly what the OP had a problem with: "... then loses all field formats set in the document properties". Depending on the inside of your document, you may want to avoid this technique.
  • REDUCE DATA (like in the File Menu in QV Desktop) = a fully loaded document will have all rows and values dropped, but the tables and their structures will remain intact. Fields will still exist, although they won't carry any values anymore. Most if not all properties will be maintained. IMHO this is what flipside's code is doing (and possibly Lucian Cotea's VBS code as well).

There is a difference.