topic Re: vba macro to open, reduce data and close in QlikView

vba macro to open, reduce data and close

m_woolf — Wed, 01 May 2013 20:04:22 GMT

I want to create a macro to open a qvw, reduce the data (remove all values), save and close the qvw.

I have code that will open and close the qvw.

What I need is code that will remove all values. Activedocument.reducedata doesn't work.

Also when I do activedocument.save, it prompts me for a file name. I just want it to save with no prompt.

Any suggestion?

Re: vba macro to open, reduce data and close

Gysbert_Wassenaar — Thu, 02 May 2013 07:57:25 GMT

ActiveDocument.SaveAs with the original file name as argument works for me to prevent the prompt.

If you need to remove all data you could create an array of the field names add pass those as second parameter to ActiveDocument.ReduceData. See attached example. In the example I hardcoded the array, but you should be able to create this by looping through the fields returned by ActiveDocument.GetFieldDescriptions.

Re: vba macro to open, reduce data and close

marcus_sommer — Thu, 02 May 2013 08:16:23 GMT

Perhaps reducedata is not allowed:

temp=ActiveDocument.GetProperties.UserPermissions.ReduceData

if not temp then msgbox("Reduce Data is not allowed")

and/or it removed also path/filename (bug/feature). This could solved per ActiveDocument.SaveAs.

- Marcus