topic Re: changing Banding-field in report in QlikView

changing Banding-field in report

Thu, 06 Dec 2012 15:46:02 GMT

Hello,

i want to change the banding field in a report.

- is there a way to set a variable in the "Banding-Field"

- how is the Syntax for changing this field in Macro.

Thank for your help

elmar

Re: changing Banding-field in report

lucas4bi — Tue, 24 Jun 2014 15:08:58 GMT

I've got the same problem as described above.

Using QV 11.20 and still haven't found a macro function to set dinamically a field for banding the report.

Is there any way to accomplish this?

Re: changing Banding-field in report

jaimeaguilar — Tue, 24 Jun 2014 15:29:04 GMT

Hi,

this is not possible through menus, maybe with some macro, but I'm not sure. However, QlikView native reporting is not really a robust solution. If your requirements grow you may need a more robust solution, you may give it a try to other solutions like NPrinting which is especially designed to deliver reports and with plenty configurable options, which cannot be done with native reporting,

regards

Re: changing Banding-field in report

bixpahalley — Tue, 22 Dec 2015 18:58:34 GMT

maybe this is the solution.!!!

' get the specific report for modify banding

Set rep =ActiveDocument.GetReport("RP01")

' remove old report

ActiveDocument.RemoveDocReport "RP01"

ActiveDocument.GetApplication.WaitForIdle

' add new dimension for banding

rep.DynamicName.v = "Report description in list report"

rep.Comment = "Comment ......."

rep.Banding.Fields = "Sales" ' Banding of Report

rep.Pages.Item(0).Banding.Fields = "Office" ' banding for pages 1

rep.Pages.Item(1).Banding.Fields = "Department" ' banding for pages 2

ActiveDocument.AddDocReport rep

ActiveDocument.Save

Re: changing Banding-field in report

rzenere_avvale — Fri, 18 Mar 2016 09:40:16 GMT

Hi Francesco,

probably I'm missing something but... Are you sure that this macro works? Specifically I'm interested in the piece that changes the banding for the single pages.

I've tried with QlikView 10SR6 and 11.20SR13 but with both versions when it comes to assign the banding field the application crashes.

I'm sure that the name of the field I'm calling is correct. It doesn't work as well if I try to set the banding field as ActiveDocument.GetField("test_field").

Do you have any suggestion?

Thanks,

Riccardo