topic Is there any function that generates a day range? in QlikView

Is there any function that generates a day range?

bvendeza — Tue, 24 May 2022 13:21:10 GMT

I'm trying to configure my chart to show results on a rolling 7-day period (Ex. if today is 5/23/2022, I want my graph to display data from 5/17/2022 to 5/23/2022).I can do a rolling 'last 3 months' using variables that utilize MonthStart, MonthEnd and AddMonths etc. But I was wondering if there's any way to do that for days? I can only find AddMonths and AddYears.

Thank you in advance!

Re: Is there any function that generates a day range?

James5654 — Wed, 25 May 2022 03:47:14 GMT

The DAY function takes just one argument, the date from which you want to extract the day. In the example, the formula is: = DAY ( B5 ) B5 contains a date value for January 5, 2016. MyCFAVisit.com

Re: Is there any function that generates a day range?

MayilVahanan — Wed, 25 May 2022 03:55:54 GMT

You can minus the days in the date function like

>$(=Date(Today()-7))<=$(=Date(Today()))

or with max date

>$(=Date(Max(DateField)-7))<=$(=Date(Max(DateField))