Using Date Filter in Qlik nPrinting

[pbrenneise]

Hello,

I have a quick question about identifying some effective options for adding a function to a filter in nPrinting so that any reports generated will only show the two most recent weeks. I have a column (for example) entitled "Week Number", which uses Qlik Sense's Week() function to tag each week as week 1-52/53 of that particular year. The desired result should be to include, for instance, week 28 and week 27 if nPrinting sees that those are the two most recent weeks. Can you use the max() function to do this? Thanks!

[JustinDallas]

The better option is to just use a flag on the your  Master Calendar or DataModel signifying that a Week# is within the last 2 weeks.  You can then set that flag property on your NPrinting filters, or even use it as a Condition to prevent the creation and distribution of a report.

[Lech_Miszkiewicz · Accepted solution]

Hi,

I agree with @JustinDallas that the best option is to use flag to achieve this, but before I start please first of all make sure that you provide correct labels to your post. NPrinting 16 is not supporting Qlik Sense ,so my initial answer would be: "you are running unsupported configuration - please use nprinting April 2020 etc...." Use of correct labels is critical as each version of NPrinting has different functionalities, hence you may receive different answers. So, which version you are actually on?

The are 2 possible methods you can achieve your requirement in NPrinting  (considering you are only running 1 year data)

1. By using filter and Evaluate option with 2 values needed to be:

• =max(Week)
• =max(Week,2) - note additional rank parameter (2)

The above filter will apply selection on 2 max weeks, but (it will also consider all other filters used!!! That being said if you are reporting on product A which was not sold in your last weeks, max function will return 2 max values but for the associated product. You would need to use some set analysis to overcome this problem like:

• =max({<Product=>} Week)
• =max({<Product=>} Week,2) 

2. By using Advanced search option in filter

https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

What you are not considering is situation when you turn over to the next year and max week will be week 1 and second last should be week 52/53. How are you aiming to solve this?

In such scenario you would probably have to use reference to date fields with possible conjunction of WeekStart() functions.

knowing the whole scenario would help provide you with better answer...