Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Highlighted
sampada0810
Contributor

Data not getting filtered as per the level in Excel Report

Hi All, I am creating a NPrinting report in Excel format, where in I have a level say Product. I want to filter data based on this level. I am able to have different sheets filtered on that level but the data in those sheets is not getting filtered. For example: Category 1 has values as- P1 - 10 P2 - 20 P3 - 40 Then for this category the Total sheet should show the value as 70 and in each sheet the values should come as above. But, in all the sheets the value is coming as 70, even if the tab values are showing as P1, P2 and P3. Please assist. Thanks Sampada
1 Reply
Employee
Employee

Re: Data not getting filtered as per the level in Excel Report

Hi,

If you want to have a different worksheet for each distinct value of PRoduct you need to insert the field Product in the Pages node. All QlikView or Qlik Sense objects you will place in the worksheets that is active at the moment you insert Products field in Pages node will be filtered by the value of the PRoduct. Read https://help.qlik.com/en-US/nprinting/November2018/Content/NPrinting/ExcelReports/Create-Excel-Repor...

If you add the Product field in the Levels node you will have a single worksheet with the list of distinct product values. All objects between the level tags are filtered. Read https://help.qlik.com/en-US/nprinting/November2018/Content/NPrinting/ExcelReports/More-Levels-Excel-...

If you need more help, please share at least your template with us so we can check your details.

Best Regards,

Ruggero



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.