Date Logic

has75042 — Wed, 25 Nov 2020 16:16:04 GMT

Hey Everyone,

I need urgent help automate dates. In the report, we have two tabs one for this TY Saturday and another one for LY Saturday.

For example, the first tab will use coming Saturday Fiscal Year date 3/16/2019 and the second tab will use LY Fiscal Saturday date 3/17/2018. How can automate the dates using the attached file.

The table I am using is in attached file.

Re: Date Logic

Shubham_Deshmukh — Mon, 18 Mar 2019 06:12:30 GMT

Hi,

If possible, create day(Saturday, Monday,...) in SQL script itself during extraction as it will save calculation time on front end, then use below expression with variables for TY and LY saturdays,

//vFiscalYearStart = YearStart(today(),0,4)

//vLYFiscalYearSTart = AddYears(YearStart(today(),0,4),-1)

//vLYToday = AddYears(today(),-1)

//vToday = date(today())

This year :

=Sum({<dates ={">=$(=vFiscalYearStart)<=$(=vToday)"},day={'Saturday'}>}sale)

Last Year:

=Sum({<dates ={">=$(=vLYFiscalYearSTart)<=$(=vLYToday)"},day={'Saturday'}>}sale)

Regards,

Shubham

topic Date Logic in QlikView

Date Logic

Re: Date Logic