Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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()))