Report with Banding

[SatyaPaleti]

Hi Friends,

Could any of you can explain what is Report with Banding. In which case we use this?? Could you please provide any example for this

Thank you,

Satya Paleti

[MK_QSL]

Use below in QlikView Script..

Load * Inline

[

  Country, Customer, Sales

  UK, A, 100

  UK, B, 120

  UK, C, 200

  GERMANY, D, 200

  GERMANY, E, 150

  GERMANY, F, 175

  FRANCE, G, 150

  FRANCE, H, 100

  FRANCE, I, 175

];

Now create a Bar Chart

Dimensions

Country

Customer

Expression

SUM(Sales)

Now go to Reports

Edit Reports

Add (Bottom Left)

Give Name to this report

Select this report and Click EDIT (Bottom Right)

Make size of Report Editor Smaller so that you can now Drag and Drop Bar Chart to blank page of Report

Click on Reports on Report Editor

Reports Settings

Selections

Banding

Tick Loop Report over possible values in Field

Select Country

Now what will happen here is your bar chart will split in three different Countries.

Banding will loop your chart/table in distinct values of fields..

Example attached for your reference..

[Kushal_Chawda]

Report Banding is the feature of QlikView report (Open Qlikview app, go to Report tab and select Edit report-> click on add)

Drag and drop the objects you want in report.

Now go to report tab-> report setting -> Selection tab-> check loop report over possible values in field

Select the field from drop down for which you want to reduce your report.

For eg. if you select Region, report will be generated for each region as separate page ( lets say you have four region EAST, WEST, SOUTH, NORTH, in this case four page will be generated for Each region )

Banding is basically reduce your chart for each values of the field used as banding.

[anjali0108]

explained amazingly. Thanks a lot.