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

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

jblomqvist — Fri, 12 May 2017 10:45:55 GMT

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 — Fri, 12 May 2017 10:49:25 GMT

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

For the dynamic parts you can use expression like

=year(today())

jblomqvist — Fri, 12 May 2017 11:05:46 GMT

Hi Robin,

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

Anonymous — Fri, 12 May 2017 11:11:48 GMT

have a look here:

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