Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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())
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())
Hi Robin,
Thank you for this. Where doe the expression go when adding a filter?
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())