Creating multiple Excel file outputs from same QlikView file

[raghavsurya]

Dear All,

We have a client who is into service industry and caters to more than 500 customers.  The customer has a standard deck of reports he is currently sending on operation data to all the customers every month manually in excel format.  we have currently built the reports in QlikView  and by selecting customer his data will be reflected in all QlikView reports.  we are trying to use NPrinting to generate excel report outputs to be sent to all the customers 

How can we trigger different excel files for all 500 customers from same QlikView file.  Do we have to design 500 individual report outputs for each customer to be triggered??. 

Please let us know is there a way to achieve this better.

Thanks and Regards,

Raghavendra

[Gysbert_Wassenaar]

NPrinting has a Distribute feature you can use for this. Perhaps one these documentshelps:

Leveraging a QlikView Section Access table to dynamically create an Nprinting Report Distribution li...‌

NPrinting Security and Distribution Information

[Daniel_Jenkins · Accepted solution]

Hi Raghavendra,

I believe you need to import all the customers as recipients and add a recipient filter for each, build a generic report add it to a task and add all the recipients to the task. When the task is run a separate file will be created filtered based on the recipient filter for each customer. Please see: How to Distribute User Specific QlikView Reports by E-mail

You can create Import Recipient tasks, use recipient groups, create Report Tasks and create schedules to automate most of the above.

To familiarize yourself with the many features of QlikView NPrinting I suggest you go through the videos and download the training materials from: NPrinting Training Material

HTH - Daniel.