topic week number in QlikView

week number

Mon, 02 Feb 2015 12:01:35 GMT

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 — Mon, 02 Feb 2015 12:05:21 GMT

Did you try week() function?

Mon, 02 Feb 2015 12:08:09 GMT

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 — Mon, 02 Feb 2015 12:09:20 GMT

please try with week() function

avinashelite — Mon, 02 Feb 2015 12:10:33 GMT

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

Mon, 02 Feb 2015 12:14:01 GMT

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 — Mon, 02 Feb 2015 12:18:54 GMT

Hi Judas,

week() function is the better option for this.

Mon, 02 Feb 2015 12:23:52 GMT

hi Avinash,

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

inweek() and inweektodate()

avinashelite — Mon, 02 Feb 2015 13:10:30 GMT

please go through this document: