Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Valued Contributor

Re: About fabs,monthend,weekday

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

balrajahlawat
Esteemed Contributor

Re: About fabs,monthend,weekday

Qlikview -> Menu Bar -> Help

Everything is explained with examples, why not check it?