Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
I am having a challenge to split sheets through nprinting filters based on Top 5 customers, let me explain I am interested to see only Top 5 customers as a summary in one sheet and based on those Top 5 customers, Second table should split like month-wise but only up to top 5 customers not all. I have two tables already in qlikview.
For better understanding please see below what I want look like.
Regards
Farrukh
Hi Farrukh,
Very easy to do in NPrinting Excel type report. Since you already have two charts appropriately filtered in QlikView, you simply need to:
This example should get you going (ignore the On-demand stuff): NPrinting - possible to page on a field and inc... | Qlik Community
HTH - Daniel.
Dear Denial,
Thanks for your help but unfortunately it starts creating sheets for all the clients not restricted to Top 5, my requirement is just to create only 5 sheets under Top 5.
I have 500 clients and it start creating 500 sheets for each client which is meaningless. In qlikview table I have taken only top 5 clients but why it is taking all clients while running through nprinting I have no idea. I am not able to handle it in a simpler way.
Hi Farrukh,
I understood that in QlikView, you have restricted your first chart to the top 5 customers. Is that right? Why not use the same logic for the second chart as well? You can always make a copy of the chart, modify and use that for your NPrinting report.
HTH - Daniel.
Hi,
As suggested by Daniel you can create a QlikView straight table object with the top 5 customers.
In Qlik NPrinting Designer you can select the second worksheet of the Excel template, add the new straight table (remember to refresh the cache before) into the Levels node then drag and drop the level tags into the template. Insert the second table between them so you will obtain a report with only the first 5 customers of 500.
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.