Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
There is a requirement to open a qvw, reduce Data and save it using Command prompt. Can it be done without using macro?
Regards,
Dawar
You can reduce to no data using the /nodata parameter.
/nodata - open document without data (all objects and script and macros, no records)
But that's it, no more flexibility.
\nodata i believe will remove the variables and table structure too.. I dont want that to happen. Just a normal reduce data that we usually do from File option in UI..Also, don't want to reload the file.
Thanks
You could try this with a vbs-batch, like:
Option Explicit
Dim QA, QD, apppath, param1, newdoc
apppath = "C:\test.qvw"
set QA = CreateObject("QlikTech.QlikView")
set QD = QA.ActiveDocument.GetApplication
set newdoc = QD.OpenDoc(apppath, "","")
newdoc.Fields("AnyField").Select "AnyValue" 'maybe a dummy-field within a loosen table
newdoc.ReduceData
newdoc.SaveAs "C:\test_Reduced.qvw"
newdoc.CloseDoc
QD.Quit
- Marcus
I think the below link should help....