Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

About fabs,monthend,weekday

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.

2 Replies
brunobertels
Master
Master

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

Anonymous
Not applicable
Author

Qlikview -> Menu Bar -> Help

Everything is explained with examples, why not check it?