I've got a table like this:
| Date |
Percent |
Count |
| 3/7/2022 |
82.49% |
1,148 |
| 3/8/2022 |
82.59% |
1,074 |
| 3/9/2022 |
83.21% |
1,108 |
| 3/10/2022 |
80.56% |
921 |
| 3/11/2022 |
80.86% |
972 |
| 3/12/2022 |
85.43% |
1,023 |
| 3/13/2022 |
82.81% |
989 |
| 3/14/2022 |
84.71% |
1,236 |
| 3/15/2022 |
84.16% |
1,326 |
| 3/16/2022 |
83.66% |
1,120 |
| 3/17/2022 |
82.37% |
1,197 |
| 3/18/2022 |
82.68% |
1,074 |
| 3/19/2022 |
87.75% |
1,069 |
| 3/20/2022 |
87.41% |
1,104 |
Using this article https://community.qlik.com/t5/New-to-Qlik-Sense/Last-7-Days-values/td-p/1519017 I've obtained last 7 days of the dataset. For comparisons I'd like to get 7 entries before that time period, e.g. previous week.
Last 7 days (most recent week) I calculated using:
=If(Date>$(MaxDayMinus7),Date(Date,'dd-MMM-YYYY')&chr(13)&Date,NULL())
and variable MaxDayMinus7:
=Max(Num(Date))-7
Can I fetch 7 entries before the last ones using similar approach?
Many thanks!
