week number

[#1]

I am looking for an expression to create a variable that hold a week number like the expression below for month number:

let vMaxMonth = '=month(max(Date_Dt))';

[Anonymous]

Did you try week() function?

[#3]

yes I have tried the following Michael but I don't know if is the right function as I am new to qlikview:

let vMaxWeek = '=week(max(Date_Dt)';

[avinashelite]

please try with week() function

[avinashelite]

hi

it depends on your requirement , what is exact requirement ?? so that we can help you with rite function

[#6]

hi Avinash,

my requirement is to get WTD data of the same week last year........eg (my week start on a sunday.....02/02/2014 )

[avinashelite]

Hi Judas,

week() function is the better option for this.

[#8]

hi Avinash,

can you send me example that you have ....cause I don't know which function to use between....

inweek() and inweektodate()

[avinashelite]

please go through this document: