topic Date in QlikView

Date

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

Hi All ,

Can someone please explain me what does the below script does ?

date(MakeDate(year(AddYears(Today(),-2,num(month(Today()))))),'YYYY-MM-DD');

Left(SalesMonth,4) & Right(salesMonth,2) as yearmonth, ???

Thanks in advance

Re: Date

Gysbert_Wassenaar — Wed, 09 Aug 2017 09:33:57 GMT

It is supposed to create a date value that's the start of this month two years ago. But the expression is not correct since the parentheses don't match up. It should be =date(MakeDate(year(AddYears(Today(),-2)),num(month(Today()))),'YYYY-MM-DD');

This also gives the wanted result, but is easier to read: Date(MonthStart(Today(),-24),'YYYY-MM-DD')

Re: Date

clickertape — Wed, 09 Aug 2017 09:35:05 GMT

Wild stab in the dark....

get todays date, get the year of this date, subtract 2 years from it, get the month of this date,format the whole thing as yyyy-mm-dd and convert it to a date

Re: Date

Anil_Babu_Samineni — Wed, 09 Aug 2017 09:35:44 GMT

First, This expression won't work because you need 2 parameters of AddYears()/ You can split into different variations

Year(AddYears(Today(), -2)) -- 2015

Num(Month(Today())) -- 8

MakeDate(2015, 😎 -- 2015-8thmonth-Starting date of the month (2015-08-01) Because, My format of date is YYYY-MM-DD

Date() -- Returns as we need

Finally, It creates a date for current month of 2 years back date

Re: Date

tresB — Wed, 09 Aug 2017 09:35:48 GMT

Do you know all the functions being used in this expression? If yes, knowing also that the expression evaluation would be inside-out (inner function's output would be passed to outer function as parameter) would help you know what it is doing. Else, if you don't understand a specific function, let know or search help.

I believe this way you would learn better.

Re: Date

smilingjohn — Wed, 09 Aug 2017 09:38:14 GMT

hi Gysbert

thanks for the reply ...i got it can you please tell me how does this work ?

Left(SalesMonth,4) & Right(salesMonth,2) as yearmonth,

Re: Date

Gysbert_Wassenaar — Wed, 09 Aug 2017 09:40:22 GMT

I'm not going to explain every single function. There's an online help where you can find what Left() and Right() do. Have a look at https://help.qlik.com/qlikview