topic Re: Creating report with banding in QlikView

Creating report with banding

spinchuk — Tue, 10 Jun 2014 21:34:14 GMT

Guys, is it possible to create a report that will print few text objects with dynamic text multiple times on the same page (one for each client)?

Suppose i have a text object (=Sum(Sales)) and I have Customers list box with 10 customers.

What I need to do is to create a report and print the text object once for each customer on the same page.

Banding by customer within page properties puts each of 10 customers and the text object on a new page, but I need to keep it within the same page.

Any ideas would be greatly appreciated.

ngulliver — Thu, 12 Jun 2014 08:18:59 GMT

Hi,

You can use set analysis to create an object for each customer but this is a clumsy and laborious method.

You may be better looking at some of the third party reporting tools for QlikView such as NPrinting or CIA.

Regards,

Neil

dharmarasu — Thu, 12 Jun 2014 08:42:02 GMT

Hi,

Looping is not possible with in the same sheet.

--->if you want to show the 10 customer in 10 text objects, you want to create separate text object for each customer.

---> otherwise u can show it in a pivot/straight table.

Dharma

SergeyMak — Thu, 12 Jun 2014 08:52:57 GMT

What are trying to achieve? What the purpose of your idea?