Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

changing Banding-field in report

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

4 Replies
lucas4bi
Partner - Creator
Partner - Creator

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?

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

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

bixpahalley
Contributor II
Contributor II

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

rzenere_avvale
Partner - Specialist II
Partner - Specialist II

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