Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

jblomqvist
Contributor II

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

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

1 Solution

Accepted Solutions
roharoha
Valued Contributor III

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

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())

3 Replies
roharoha
Valued Contributor III

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

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
Contributor II

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

Hi Robin,

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

roharoha
Valued Contributor III

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

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())

Community Browser