topic Re: Clarification regarding Weekend() in QlikView

Clarification regarding Weekend()

Anonymous — Mon, 10 Jul 2017 12:31:48 GMT

Hi all,

I am using Qlikview 11 and wanted clarification regarding weekend() function. below is the expression and it's results. i am really confused about the results and need help.

date format is m/d/yyyy.

weekend('1/3/2017',1,-1), result is 1/14/2017. Why is its so?. Here i am asking the weekend date of the previous week, which should be 1/2/2017 as i am using offset 1(Tuesday is the first day of the current week right? and 3rd January is Tuesday).

Also is there anyway to know the value of the variable firstweekday already loaded in qlikview?

Will be glad to get some help from you all.

Thanks in advance.

Re: Clarification regarding Weekend()

sunny_talwar — Mon, 10 Jul 2017 12:37:15 GMT

I think you have misplaced -1 and 1, try this

WeekEnd('1/3/2017',-1,1)

Re: Clarification regarding Weekend()

tresB — Mon, 10 Jul 2017 12:39:17 GMT

The arguments are like: WeekEnd(date [, period_no = 0 [, first_week_day=0]])

Then to get your desired result you should try exchanging your parameters, like : =weekend('1/3/2017',-1,1)

Re: Clarification regarding Weekend()

Anonymous — Mon, 10 Jul 2017 12:40:02 GMT

Thanks a lot Sunny. it worked

Re: Clarification regarding Weekend()

Anonymous — Mon, 10 Jul 2017 12:41:37 GMT

Thanks Tresesco. problem got resolved as you and sunny suggested. Carelessness on my part.