topic ActiveDocument.ReduceData not working in QlikView

ActiveDocument.ReduceData not working

Thu, 05 Nov 2009 07:45:04 GMT

I've trying to get ReduceData working on a document, but before I insert it my main script I created a simple sub which only runs ReduceData, but it's been stalling everytime and if I reduce from the file menuj it's very quick. This is all my sub is doing


Sub TestReduce
ActiveDocument.ClearAll true
ActiveDocument.ReduceData false, null
End Sub

Am I missing something?

ActiveDocument.ReduceData not working

Thu, 05 Nov 2009 07:48:56 GMT

How are you triggering this code? Via a manual reload in QV Desktop or through a publisher/server reload?

And why would you clearall and then try to reduce the data?

ActiveDocument.ReduceData not working

Thu, 05 Nov 2009 07:53:27 GMT

Right now I'm triggering it with a button, but it will run OnPostReload with a qv.exe /r

my mistake, clearall won't be there, but with or without it, it still stalls.

ActiveDocument.ReduceData not working

Thu, 05 Nov 2009 08:02:42 GMT

I set system access on requested module security and it works now

ActiveDocument.ReduceData not working

Thu, 05 Nov 2009 08:08:19 GMT

whoa sorry for the multiposts but I was getting a .net error

ActiveDocument.ReduceData not working

Fri, 15 Jan 2010 22:03:26 GMT

Hi,

I am actually having the same problem and I'm wondering what your .net error was. I have a macro that I invoke post reload. It makes a one field selection and then ActiveDocument.ReduceData. Qlikview "stalls" for 15 to 20 minutes, then continues on with the macro. When it's done, no data reduction has taken place. When I perform the data reduction from the File menu and Keep Possible Values it completes in seconds. So, if you have any insights, I would be interested.

Thanks,

Bret

Re: ActiveDocument.ReduceData not working

Mon, 22 Apr 2013 08:02:13 GMT

Hi everyone,

although your posts are are from 2010 this still happens. Additionally, you may not combine

ActiveDocument.clearall

ActiveDocument.reload

as QlikView will crash immediately with no option other than terminating the programm.

Best regards

Urs