Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
raghavsurya
Partner - Specialist
Partner - Specialist

Creating multiple Excel file outputs from same QlikView file

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

1 Solution

Accepted Solutions
Daniel_Jenkins
Specialist III
Specialist III

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.

View solution in original post

2 Replies
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


talk is cheap, supply exceeds demand
Daniel_Jenkins
Specialist III
Specialist III

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.