How to create last seven days Flag in Qlik sense

[sat_tok52]

Hi All,

I have to create last seven days flag in script ,instead of today() i have to take  max date of my date less than 7 days . Any help.

IF(Date >max(Date)-7,1,0)

Thanks,

[Kushal_Chawda]

@sat_tok52  look at  below

https://community.qlik.com/t5/Documents/Calculating-rolling-n-period-totals-averages-or-other/ta-p/1...

[menta]

You can load the fact table and store the max date into variable.

DateTmp:

Load Max(Date) as MaxDate

resident <your fact table>;

Let vMaxDate = peek('MaxDate',-1,'DateTmp');

NOW

IF(Date >$(vMaxDate )-7,1,0)