topic Re: Help: How to filter a single PixelPerfect NPrinting report Table? E.g. Filter the data in a chart to just 2017 in Qlik NPrinting

Help: How to filter a single PixelPerfect NPrinting report Table? E.g. Filter the data in a chart to just 2017

jblomqvist — Thu, 11 Jan 2018 11:07:25 GMT

Hello,

How add a filter to an NPrinting Table? E.g. Filter the data in a chart to just 2017. Or the rolling last 12 months.

I am aware of how to create a Filter in the Filter page of NPrinting, however I am not sure how to add this filter to a Table inside an NPrinting PixelPerfect report.

Can anyone please show how to do this?

Re: Help: How to filter a single PixelPerfect NPrinting report Table? E.g. Filter the data in a chart to just 2017

Giuseppe_Panella — Thu, 11 Jan 2018 14:45:12 GMT

Hi John,

you can take a look at this brief video that probably could help you

Re: Help: How to filter a single PixelPerfect NPrinting report Table? E.g. Filter the data in a chart to just 2017

jblomqvist — Thu, 11 Jan 2018 19:18:22 GMT

Hi GIuseppe,

The problem is I have to apply Filter at an Chart Object level inside the PixelPerfect report.

E.g. Inside the report I have two charts, one chart should have a filter for 2017 and another chart should be left alone.

How do I apply a filter at a report level?

I don't think the Filter option in the video applies to NPrinting PixelPerfect reports so I am looking for a way to do this in PixelPerfect.

Re: Help: How to filter a single PixelPerfect NPrinting report Table? E.g. Filter the data in a chart to just 2017

Daniel_Jenkins — Thu, 11 Jan 2018 23:41:47 GMT

Hi John,

Perhaps this will work for you?

1. Add the chart twice as separate levels and DetailReport bands

2. Filter one DetailReport instance as required.

Example:

To get:

HTH - Daniel.

Re: Help: How to filter a single PixelPerfect NPrinting report Table? E.g. Filter the data in a char

Hatus — Sat, 19 Jan 2019 10:34:11 GMT

Hi Daniel

Does it work only if the filtered field also exists in the chart as a dimension?

It seems not to work if you want to filter another dimension. In your example would be for example a department.

How can we do this?

Thank you for your reply.

Regards

Re: Help: How to filter a single PixelPerfect NPrinting report Table? E.g. Filter the data in a char

Daniel_Jenkins — Sun, 20 Jan 2019 00:02:51 GMT

Hi,

As you discovered, the dimension must exist in the chart.

HTH - Daniel.