How to restrict data in NPrinting tables based on multiple field values? (I use QlikView NPrinting 16.4)

[jblomqvist]

Hello all,

I have a table that shows me Sales for my organisation. This table will be in NPrinting PowerPoint report (I use QlikView and NPrinting 16.4).

When this report is printed I would like to filter this table by:

Country: Germany, France, Switzerland

Year: 2017 (dynamic where current year is selected)

Month: May (dynamic where current month is selected)

Product Type: Shoes

Source: Web orders

Does anyone know how I can achieve this efficiently?

The table in QlikView is quite organic and you would normally make selections to see the data there, in NPrinting I am wondering what I have to do.

Thanks

[Anonymous · Accepted solution]

define and use a filter, that's all...

QlikView NPrinting 16 Tutorials - Filters & Cycles

For the dynamic parts you can use expression like

=year(today())

[jblomqvist]

Hi Robin,

Thank you for this. Where doe the expression go when adding a filter?

[Anonymous]

have a look here:

How to Create Static and Dynamic Filters Based on Fields

1) either you use  with activated evaluate,

then your expression is

year(today())

2) or you use advanced search, then deactivate evaluate and your expression could be

=YourYearField=year(today())