topic Re: Macro to Reduce Data after Reload in QlikView

Macro to Reduce Data after Reload

Wed, 24 Feb 2010 04:39:50 GMT

Using QlikView 8.5. I would like to execute a reduce data command after reloading a template. I have created a macro which makes some selections on the data and then attempts to reduce data. I have then attached that macro to the OnPostReload event trigger.

sub AfterReload

ActiveDocument.Fields("SubRegion").Select "NNI")

ActiveDocument.Fields("SubRegion").ToggleSelect "ENI")

ActiveDocument.ReduceData

end sub

The selection part of the macro works fine but the macro editor pops up at the ReduceData line. If I then save the template and re-open it I can successfully run the AfterReload macro without any problem. I have also noticed that after the reload, I cannot use the File / Reduce Data / Keep Possible Values command - no errors, just nothing happens.

This is really frustrating and any suggestions would be gratefully received.

Thanks, Kevin Long

Re: Macro to Reduce Data after Reload

Fri, 10 Aug 2012 09:20:06 GMT

I have a lot of QVW files, how should I batch reduce data?

Re: Macro to Reduce Data after Reload

IAMDV — Fri, 10 Aug 2012 10:12:23 GMT

Have you considered using Publisher?

Thanks,

www.QlikShare.com

Re: Macro to Reduce Data after Reload

msteedle — Fri, 10 Aug 2012 22:14:30 GMT

Your script worked fine for me, albeit in v11. The only issue was that you have extraneous closing parentheses at the end of each of your selection lines.