Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I have a requirement to generate customer monthly invoices. In the customer dimension i have around 200 customers , so i want to generate 200 pdf invoices using QlikNprinting.
Does anyone tried this kind of bursting or applying filters dynamically in QlikNprinting to achieve this kind of functioning ?? If yes, I would like ask you to share your experiences and thoughts how you were able to do it in Nprinting with this bursting on a dimension (like customer)
Best Regards
Vamsi
Assuming you know the basics of nprinting, all you need to do is to use Customer name as your cycle field in the nprinting report, it will automatically create separate invoice file for each of the customer.
Assuming you know the basics of nprinting, all you need to do is to use Customer name as your cycle field in the nprinting report, it will automatically create separate invoice file for each of the customer.
@Digvijay_Singh Thank you for your quick response. I will try it out. I have to you ask you another scenario as well. In the same invoice, I should print Customer name, Customer address info fields. So how could we pass these fields in Npriting report from an Qliksense app??
My case is following
I have an Qliksense app with CustomerID , Customer Name, Customer Address in Filter and his monthly data in a table. I created a report in Npriting out of this app but try to fill these fields like name,address,monthly data dynamically for each customerid.
Since you are using Customer Name as a cycle field, You can use other fields as well and define them as formula over here -
Make sure your cycle field used below has unique values, else it will combine data for duplicated values -
and use like this : - <field name> in the report to access them dynamically
Hi,
Please, when posting new questions in the community add only the label of the version of Qlik NPrinting you are using because the answer could depend on it. Also, avoid making confusion by adding labels that do not matter to this area of the community like QlikWorkd 2023. Thanks for your cooperation.
Based on your questions I think you are new to Qlik NPrinting. In this case you must start with training. Qlik NPrinting is an enterprise-class software and you cannot simply sit down in front of it and start using it. Your question, deliver filtered reports (invoices are a kind of report), is well documented for example in https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/Introduction/Get-started.htm.
Then you did not specified what kind of template you are developing. To create PDF reports I suggest you to use PixelPerfect which is documented at https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/PixelPerfectReports/Intro-PixelPerfe... including how to insert fields from Qlik Sense, like customer name, in the template.
Then you have to decide how you want to deliver those invoices and set your Qlik NPrinting installation in order to do that.
Best Regards,
Ruggero
Hi, to link your customers to your invoices you will first need to import all customers and create them as a NPrinting users with associated email (given that email needs to be sent automatically), also create for each of them using user filters and likely add them to the group so group can be used in task distribution. As @Ruggero_Piccoli said all this requires prep and training and is well documented on help.qlik.com web page
HI @VamsiBhagavathula1, what @Digvijay_Singh suggests will produce single zip file with with pdf for every customer, but you would have to distribute it manually to customers.
Or if destination folder is set up in the task, pdf/ppt for each customer can be generated dynamically in the configured folder. But as suggested by our experts @Ruggero_Piccoli and @Lech_Miszkiewicz, you will need to understand the nprinting development life cycle well documented in the help.qlik.com web page.