Table filter by date in Nrpinting Pixelperfect

[dvilloldo]

Hi.

We have a problem filtering data for a NPrinting Pixelperfect report. The origin of data is a straight table in a Qlik Sense application linked through a NPrinting connection.

The table is simple:

Date (dimension) - Measure1 (count) - Measure2 (sum) - Measure3 (Measure2/Measure1, percentage)

The table have information about many years.

And we want to show in the Pixelperfect report this table, but only one month of information.

How to do it? Can anyone explain simple tips obout this?

Thank you and greetings.

Daniel Villoldo

[Lech_Miszkiewicz]

Hi

This seems like very basic question - Are you just starting and learning the very basic things in NPrinting? If this is a case got to https://help.qlik.com and read about NPrinting filters and about creating pixel perfect tabe.

https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ReportsDevelopment/Static-dynamic-...

https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/PixelPerfectReports/Simple-PP-Repo...

also as you want to filter whole month the best approach is to create a month-year field in your Qlik Sense data model by using formula like:

Date(MonthStart([yourdatefield])) as [Month Year] 

so then you could reference it in NPrinting filter much easier.

More about pitfalls and traps in NPrinitng you can read on my blog

https://nprintingadventures.wordpress.com/

[Lech_Miszkiewicz]

btw - you have not provided us with information about version of NPrinitng you are using so I gave you an answer based on NPrinting April 2019