Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I think you have misplaced -1 and 1, try this
WeekEnd('1/3/2017',-1,1)
I think you have misplaced -1 and 1, try this
WeekEnd('1/3/2017',-1,1)
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)
Thanks a lot Sunny. it worked
Thanks Tresesco. problem got resolved as you and sunny suggested. Carelessness on my part.