Very easy to do in NPrinting Excel type report. Since you already have two charts appropriately filtered in QlikView, you simply need to:
- place your Summary chart on Sheet1 (rename the sheet as required).
- place your other chart on Sheet2 and Page by field Customer (only on Sheet2)
This example should get you going (ignore the On-demand stuff): NPrinting - possible to page on a field and inc... | Qlik Community
HTH - Daniel.
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.
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.
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.