Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
MaqM
Contributor
Contributor

Pull the last 6 weeks Data on Qlik Sense via NPrinting

Hi All, 

Please assist, I need to pull the last 6 weeks data in weekly buckets with 2 variables on a bar chart from Qlik Sense via NPrinting Reports.

For my Filters I used the below:

I have tried = week(today())-1, which gives me the past week.

I have tried substituting the -1 with -3 for i.e. =week(today())-3 but that gives me just one week, 3 weeks ago.

Please assist. 

Please see example attached.

 

 

Labels (2)
1 Reply
TheLazyDeveloper

This article should steer you in the right direction:
https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

The NP filter should come out to something like this:
Advanced search: =([week]>week(Today())-6)*([Week]<=week(Today()))