topic Re: Powershell to archive ole QV documents in QlikView

Powershell to archive ole QV documents

Anonymous — Fri, 20 Nov 2020 18:02:30 GMT

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,

Chanty4u — Tue, 08 Dec 2015 10:54:07 GMT

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

Hope this helps

jerrysvensson — Tue, 08 Dec 2015 11:11:18 GMT

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

Anonymous — Tue, 08 Dec 2015 11:17:52 GMT

hi,

Could you please elaborate a little bit.