Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
fabs(MonthEnd(Today())- WeekDay( MonthEnd(Today())+1 ))
Above Expression, What it will return Exactly.Explain each function what it will return exactly.
Please help me out this issue.
Thanks in Advance.
Regards
prathap.
Hi
fabs(MonthEnd(Today())- WeekDay( MonthEnd(Today())+1 ))
Fabs() return an absolute value it's mean a positive value
today() give the date of to day ( 02/24/16)
monthend () give the last date of a month so monthend(today()) give the last date of the today's month (02/29/16)
weekday give the number of the day in the week ( between 0 and 6 )
so
WeekDay( MonthEnd(Today())+1 ) give the number of the day in the week from the first day of next month (03/01/16)
so it's give 2 as result
then
02/29/16 MonthEnd(Today())
minus
2 WeekDay( MonthEnd(Today())+1
=
02/27/16
hope it's clear
Bruno
Qlikview -> Menu Bar -> Help
Everything is explained with examples, why not check it?