topic Re: Remove data from qvw with command line in QlikView

Remove data from qvw with command line

hopkinsc — Thu, 13 Jun 2013 11:14:16 GMT

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

Re: Remove data from qvw with command line

Gysbert_Wassenaar — Thu, 13 Jun 2013 11:28:40 GMT

Perhaps with a vbscript script file

Set MyApp = CreateObject("QlikTech.QlikView")

Set MyDoc = MyApp.OpenDocEx("D:\MyFile.qvw",0,False)

MyDoc.ReduceData

MyDoc.SaveAs("D:\MyFile.qvw")

MyDoc.CloseDoc

Set MyApp = Nothing

Re: Remove data from qvw with command line

hopkinsc — Thu, 13 Jun 2013 11:42:47 GMT

Hi,

Thanks for your reply.

I don't know what i am doing wrong (im not very good with vbscript).

the vbscript seems to open and save the file but it doesnt do any reduction..

Is there any chance you could take a look to see if there is anything obvious that i am doing wrong please?

I have attached a sample file.

Many thanks

Re: Remove data from qvw with command line

hopkinsc — Thu, 13 Jun 2013 13:57:57 GMT

Does anyone have any ideas please?:)

Re: Remove data from qvw with command line

rustyfishbones — Thu, 13 Jun 2013 14:07:52 GMT

Add FIRST 1000 before the LOAD script and it will only load the first 1000 rows

like this

Re: Remove data from qvw with command line

hopkinsc — Thu, 13 Jun 2013 14:11:28 GMT

Hi Alan,

Thanks for your reply.

we need this to run automatically in our backup routine. so limiting the load to 1000 rows is not possible.

the vbs option that Gysbert suggested is perfect but can't get it to work.

Re: Remove data from qvw with command line

hopkinsc — Thu, 13 Jun 2013 14:45:18 GMT

Does anyone else know how i could do this please? or maybe perform a limitied load via a command line / vbs?

Re: Remove data from qvw with command line

hopkinsc — Fri, 14 Jun 2013 08:21:09 GMT

Any ideas?

Re: Remove data from qvw with command line

Gysbert_Wassenaar — Fri, 14 Jun 2013 11:15:47 GMT

Well, it would be perfect if you could tell that function to clear all the data. What it actually seems to do is remove the data that isn't selected. I suppose you could add a bogus value to one of the tables, select that value and then reduce the data so only the bogus value remains. Not exactly perfect unfortunately.

Re: Remove data from qvw with command line

hopkinsc — Fri, 14 Jun 2013 12:18:25 GMT

Thanks for your help on this Gysbert. i will try that

Re: Remove data from qvw with command line

jonathandienst — Fri, 14 Jun 2013 12:31:52 GMT

So you want to save the layout for backup purposes.

Have you considered using the -prj method? This saves the layout complete with formats (but no variable values).

To create the layout backup:

Create a folder with the same name as the document and add -prj to the end. eg For Test.qvw, create folder Test-prj.
Save the document, and the -prj folder will be populated with the layout data from the model in XML format.
Point your backup to all files in the -prj folders.
The XML files with changes will be updated each time the model is saved (which will happen after scheduled reloads).

To recreate from the backup:

Close the document if it is open. If the document is lost, create a new, empty QVW file with the same name.
Copy the XML files from the backup into the -prj folder
Open the document. The layout from the XML files will be applied to the document.
Reload if necessary.

No special step to run a VBS script...

Hope that helps

Jonathan

Re: Remove data from qvw with command line

flipside — Fri, 14 Jun 2013 13:51:41 GMT

If you still need the command line option, you could add this code at the end of your script which seems to do the trick - it just inner joins each table with null values. Just pass the parameter in the cmd line to trigger it ...

If '$(vUnload)' = 1 then

For t = NoOfTables()-1 to 0 step -1

tbl = TableName(t);

fld = FieldName(1,'$(tbl)');

let cmd = 'Null() as $(fld)';

inner join ($(tbl))

Load $(cmd) autogenerate 1;

next t;

End If;

vUnload = 0;

C:\Program Files\QlikView\qv.exe /r /vvUnload=1 C:\Folder\File.qvw.

flipside

Re: Remove data from qvw with command line

Fri, 14 Jun 2013 18:11:45 GMT

Use this VBS:

Set MyApp = CreateObject("QlikTech.QlikView")

Set MyDoc = MyApp.OpenDoc("Sample.qvw","","")

Set ActiveDocument = MyDoc

MyDoc.RemoveAllData

MyDoc.SaveAs("Sample.qvw")

MyDoc.GetApplication.Quit

Set MyDoc = Nothing

Set MyApp = Nothing

Re: Remove data from qvw with command line

hectorgarcia — Fri, 17 Apr 2015 13:29:00 GMT

if it is for backup purposes why dont you try the reduce option in the QMC and backup the qvw produced by the backup?

the only thing that you will loose is the script , but you will have the app with the data and the full GUI objects.

sounds weird but i think its a creative way to do it with just using the qmc

Re: Remove data from qvw with command line

Thu, 14 Apr 2016 15:03:57 GMT

Hi,

Inspired by flipside's response, I try doing something like this:

Create a variable vExit with no value. Then put this code after initial SET definitions:

if $(vExit) = 1 then

trace('Stopping Data Load');

LET vExit = 0;

EXIT Script;

ELSE

trace('Running Script');

ENDIF

Then pass vExit=1 in command line (from qlikview folder): Qv.exe /r /vvExit=1 c:\Path\to\Sample.qvw

This way you should get a qvw with no data at all. I am rather new to QlikView and still checking if this method has any downsides, but I hope to use it with SVN synch (before commit).

Re: Remove data from qvw with command line

Gysbert_Wassenaar — Thu, 14 Apr 2016 17:00:37 GMT

That works fine. I've implemented that myself. The disadvantage is that you need to modify the script of the document first.

Another solution I have used is creating an excel file with a list of file names and run a vba macro in excel to create a Qlikview instance, open each qvw file in turn, remove its data, and finally save and close the file.

Re: Remove data from qvw with command line

adriano_fornoni — Thu, 27 Oct 2016 09:01:59 GMT

Thanks, it works fine.

Re: Remove data from qvw with command line

Mon, 07 Nov 2016 11:00:37 GMT

Adriano

can you please share your sample script, even I too need this coding for me.

Thanks

Re: Remove data from qvw with command line

adriano_fornoni — Tue, 08 Nov 2016 08:30:38 GMT

Hi Srinivasan,

the code is:

Set MyApp = CreateObject(QlikTech.QlikView")

Set MyDoc = MyApp.OpenDocEx("sourcePathFile&docFileName", 0, False)

Set ActiveDocument = MyDoc

MyDoc.RemoveAllData()

MyDoc.SaveAs("destinationPathFile&docFileName")

MyDoc.CloseDoc()

MyApp.Sleep 2000

MyApp.Quit()

Set MyDoc = Nothing

Set MyApp = Nothing

There are some little difference due to my Windows Server (release 2012). The first is MyDoc.GetApplication.Quit in

MyDoc.CloseDoc() and MyApp.Quit() and the secod is MyApp.Sleep 2000.

It is due to the information load times at the interface opening QlikView Desktop.

Bye

Adriano

Re: Remove data from qvw with command line

Tue, 08 Nov 2016 08:59:09 GMT

But when I am using at the QV script, I am getting object can not be create by Qlikview tech..