topic Date format code that gives week number? in QlikView

Date format code that gives week number?

Fri, 21 Oct 2011 18:00:07 GMT

Does anyone know if I can get a week number from a QlikView date format code? Maybe something like 2011W43 for the 43rd week of 2011 ? I know there's a Week function that returns week number but I'd like to use a date format code so that I can avoid adding another expression to a big chart.

Date format code that gives week number?

Fri, 21 Oct 2011 18:45:02 GMT

try something like =Year([Inv Date])&'W'&Left(WeekName([Inv Date]),2) to get the result in the format YYYYW##.....if that works for you

Date format code that gives week number?

Fri, 21 Oct 2011 18:45:51 GMT

Pls replace <Inv Date> with what holds the date in your app.

Date format code that gives week number?

Fri, 21 Oct 2011 18:50:57 GMT

Pls use =Year([Inv Date])&'W'&Right(WeekName([Inv Date]),2) instead of the one above.....my date format was a bit different.

Date format code that gives week number?

Thu, 03 Nov 2011 13:44:05 GMT

Thanks for the reply. I was looking for a date format code not an expression. Oracle has a week of the year code that can be used like this TO_CHAR(MYDATECOLUMN,'WW'). If I had a date format code then I could put it into the Document Properties Number tab and when I use the field in a chart dimension it wouldn't be a calculated dimension. I would need a calculated dimension in order to use an expression in the chart dimension and I wanted to avoid that for performance reasons. I may try loading a small table of dates and week of year field and give the user a cycle group to choose between the regular date or a week of the year date. Thanks.

Date format code that gives week number?

swuehl — Thu, 03 Nov 2011 15:49:28 GMT

Tim,

if it's all about avoiding the calculated dimension, why not add a field to your datamodel, with the date formatted like JasleenP_SR suggested?

Regards,

Stefan

Re: Date format code that gives week number?

Tue, 12 Jul 2016 13:28:55 GMT

this might work. Order date format: 'MM/DD/YYYY'

replace(WeekName(OrderDate),'/','W') as WeekNum,