topic Re: Need help in dates in QlikView

Need help in dates

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

Hey Everyone,

In our calendar dim table, I have FY, FY Period, and day of period column. Right now I am manually entering dates in the script and ruining the report. I need some help to automate the dates.

The report will run weekly on Sundays. In the report I have two tabs one for TY and other one for LY

TY the will be 5/4/2019. I can use this function let vTodayDate = date(today()-1) to get this year date.

I can't figure out last year date

LY tab the date will be 5/5/2018. Is there a way I can automate the dates using the calendar dim table.

Thanks in advance.

Re: Need help in dates

dplr-rn — Thu, 02 May 2019 16:56:38 GMT

dont understand the logic compltely but
Did you check the addyears function?

Re: Need help in dates

has75042 — Thu, 02 May 2019 17:48:37 GMT

Addyears will only work if it is a one to one match right?

Re: Need help in dates

dplr-rn — Thu, 02 May 2019 18:03:26 GMT

not clear what you mean.
share a few examples.
as i said i am unclear on your calculation logic .
i saw that when TY the will be 5/4/2019 LY is 5/5/2018.
Why is LY not 5/4/2018?

Re: Need help in dates

rubenmarin — Thu, 02 May 2019 19:29:29 GMT

Hi, if you use "let vTodayDate = date(today()-1)" to get TY date, LY date can be "let vTodayDate_LY = AddYears(date(today()-1), -1)"