topic Re: Weekname format in QlikView

Weekname format

Mon, 20 Jun 2011 15:27:04 GMT

Let say I have Weekname('2011-06-21') which return 2011/25, but behind it is the date of 20/06/2011 (first day of the week).

Now, I need the date of the first day of the same week in 2010 (ie. 2010/25). What would be the simplest solution.

I can't use AddMonths(Weekname('2011-06-21'),-12), as it won't be accurate

Is there such function Date#('2010/25','YYYY/WW')?

The display of '2011/25' must follow a certain format, if behind it stores numeric value. But which format is it?

Thanks in advance for your help

Re: Weekname format

Miguel_Angel_Baeyens — Mon, 20 Jun 2011 15:34:31 GMT

Hi,

What about

WeekName(AddYears('21/06/2011', -1))

Is this what you are looking for?

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Weekname format

Mon, 20 Jun 2011 15:34:41 GMT

Hi Allano.

Hope this help

You can use this fuction to create the LY date:

MakeWeekDate ( YYYY [ , WW [ , D ] ] )

Returns a date calculated from the year YYYY, the week WW and the day-of-week D.

If no day-of-week is stated, 0 (Monday) is assumed.

Examples:

makeweekdate( 1999,6,6 )

returns

1999-02-14

makeweekdate( 1999,6 )

returns

1999-02-08

Weekname format

kaushiknsolanki — Mon, 20 Jun 2011 15:35:15 GMT

Hi,

Yes there is a Date#() function.

But i m not sure in which format it stores it, Date or number.

Regards,

Kaushik Solanki

Re: Weekname format

nagaiank — Mon, 20 Jun 2011 17:44:28 GMT

Please see if the expressions in the attached qvw file for the various expressions that may give the results you want.

Hope this helps.

topic Re: Weekname format in QlikView

Weekname format

Re: Weekname format

Weekname format

MakeWeekDate( YYYY [ , WW [ , D ] ] )

Examples:

Weekname format

Re: Weekname format

MakeWeekDate ( YYYY [ , WW [ , D ] ] )