topic Report Banding over all values in QlikView

Report Banding over all values

qlik_venu — Mon, 21 Nov 2011 14:09:15 GMT

Hi,

I have a report where i have enabled banding over a FIELD1.

But its mostl likely that the user will be selecting a value in the FIELD1.

and now if they go to print the report, since we have already a selected value in the FIELD1, the report prints only for the selected value.

How can i make the banding enabled for all the values and not just for the possible values.

Thanks,

Venu

Report Banding over all values

sridhar240784 — Mon, 21 Nov 2011 14:52:35 GMT

Hi Venu,

Can you ellaborate your Question bit more.

Printing the report means, i assume that your user going to print the report by going to Report Menu--> Print Report.

What you can do is, You can create dummy report with same information and use this report for generating report by suppression the selection in FIELD1 using set analysis.

Hope this helps you.

-Sridhar

Re: Report Banding over all values

qlik_venu — Tue, 22 Nov 2011 09:23:54 GMT

hi Sridhar,

Yea am trying to Report Menu -> Print Report.

Can you please explain the set analysis approach you have suggested. thanks a lot.

Venu

Re: Report Banding over all values

sridhar240784 — Tue, 22 Nov 2011 13:58:36 GMT

Hi Venu,

Have look at the attached application.

I have two same report in my sample application, "Report With Selection" and "Report Without Selection".

"Report With Selection" - Will Accept the selection from the list box and

"Report Without Selection" - Will Not accept any seelction from the list box.

So i have created a pdf report with the "Report Without Selection", so PDF o/p will not have any selection.

Hope this helps you.

-Sridhar

Re: Report Banding over all values

qlik_venu — Tue, 22 Nov 2011 17:32:14 GMT

Hi Sridhar,

Thanks for the approach.

I also created a bookmark which would null all selections of a field. And then linked this bookmark to the page settings. By this whenever i give a print, the bookmarks unselects all the values of the field.

Thanks,

Venu

Re: Report Banding over all values

qlik_venu — Tue, 22 Nov 2011 17:32:57 GMT

Hi Sridhar,

Thanks for the approach.

Thanks,

Venu

Report Banding over all values

giuval45 — Sat, 21 Apr 2012 13:18:47 GMT

Hi Sridhar, simple and effective 😉 Many thanks, Giulio (Italy)