Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi @Didi420
if I got you,
try to used with Peek() and Previous() functions
here you have more details -
Peek() vs Previous() – When to Use Each - Qlik Community - 1475913