Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
meetmrudul
Contributor II

Powershell to archive ole QV documents

Hi All,

We have a folder with N number of documents and each with size of around 3-4 GB.

Now, we want to archive the same, as its taking lot of space.

We would like to reduce all the documents and take a backup of same, and then delete all these.

I heard using Powershell, we can automate few processes for QV.

Can anyone please tell me how we can automate to reduce all the documents in the folder and archive same.

We need automation, as its taking long time to open each document.

Please let me know your inputs.

Thanks & Regards,

MK

3 Replies
Chanty4u
Esteemed Contributor III

Re: Powershell to archive ole QV documents

You can remove DOC cals of the dashboard from QMC and Copy and paste to archive folder for future use

Hope this helps

Partner
Partner

Re: Powershell to archive ole QV documents

Not very good at Powershell, but this could be used in a vbs script.

Application not using Section Access, open with no data. See API Guide for more information

Set MyApp = CreateObject("QlikTech.QlikView") 
Set MyDoc = MyApp.OpenDoc ("test.qvw",1,false,"","","",true) 

MyDoc.Save
MyApp.Quit

meetmrudul
Contributor II

Re: Powershell to archive ole QV documents

hi,

Could you please elaborate a little bit.