topic Re: Macro Query in QlikView

Macro Query

hopkinsc — Thu, 11 Oct 2012 16:57:59 GMT

Hi everyone.

I have the following macro which loops through a region field and prints the dashboard sheet for each region.

SUB PrintDashboardByRegion

SET val=ActiveDocument.Fields("Region.Region").GETPOSSIBLEVALUES(100)

FOR i = 0 to val.count-1

ActiveDocument.Fields("Region.Region").SELECT val.item(i).Text

' ActiveDocument.ActiveSheet.print

ActiveDocument.ActiveSheet.Dialogprint

END SUB

I want to change it to instead of printing the dashboard sheet i want it to print a report but i still want it to loop through the same field.

Can anyone help please?

The report name is

Weekly Sales Report.

We have publisher, but i want any user to be able to do this from the access point.

Is this possible?

Thanks

rwunderlich — Thu, 11 Oct 2012 19:42:28 GMT

You don't need a macro for this (and you are better off without it). The capability to loop over a field is included in the Report feature.

In Report Settings, Selections tab, Banding section -- you can select a field to loop over when printing.

-Rob

hopkinsc — Fri, 12 Oct 2012 08:39:13 GMT

Thanks for that, i didn't realise that could be done.