topic Re: Can we use Commandline to Reduce Data in a QVW file? in QlikView

Can we use Commandline to Reduce Data in a QVW file?

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Can we use Commandline to Reduce Data in a QVW file?

tresB — Wed, 22 Jun 2016 08:42:38 GMT

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.

Re: Can we use Commandline to Reduce Data in a QVW file?

Wed, 22 Jun 2016 10:27:43 GMT

\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

Re: Can we use Commandline to Reduce Data in a QVW file?

marcus_sommer — Wed, 22 Jun 2016 10:55:40 GMT

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

Re: Can we use Commandline to Reduce Data in a QVW file?

trdandamudi — Wed, 22 Jun 2016 11:07:29 GMT

I think the below link should help....

Remove data from qvw with command line

Re: Can we use Commandline to Reduce Data in a QVW file?

jhamard — Mon, 21 Nov 2016 18:46:07 GMT

Vote for my idea : 😉