Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

farru_scorpio
New Contributor III

Splitting Sheets Based on Top 5 Clients

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.

split.PNG

Regards

Farrukh

4 Replies
Employee
Employee

Re: Splitting Sheets Based on Top 5 Clients

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:

  • 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.

farru_scorpio
New Contributor III

Re: Splitting Sheets Based on Top 5 Clients

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.

Employee
Employee

Re: Splitting Sheets Based on Top 5 Clients

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.

Employee
Employee

Re: Splitting Sheets Based on Top 5 Clients

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.

Community Browser