topic Report with Banding in QlikView

Report with Banding

SatyaPaleti — Tue, 07 Jul 2015 05:54:40 GMT

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

Re: Report with Banding

MK_QSL — Tue, 07 Jul 2015 06:05:32 GMT

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..

Re: Report with Banding

Kushal_Chawda — Tue, 07 Jul 2015 06:33:00 GMT

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.

Re: Report with Banding

anjali0108 — Wed, 14 Mar 2018 17:56:18 GMT

explained amazingly. Thanks a lot.