topic Generating sequence number in QlikView

Generating sequence number

Fri, 29 Jul 2011 09:09:41 GMT

Hi,

How to create a sequence number for the Weeks available in calendar table from start to end date....

Calendar dimension have 2 years(2010 and 2011) of data and I need to generate the week number for these years...

Week numbers of 2010 will be from 1 to 52...for 2011 it should be start from 53... So week numbers of 2011 should be 53-104...

Generating sequence number

Fri, 29 Jul 2011 09:25:44 GMT

Hi shans,

i you can try to use the autonumber() like autonumber(year(date) & week(date), 1) AS WeekSerial. If the sorting of year and weeks fits, this should work as you want it.

HtH

Roland

Generating sequence number

Fri, 29 Jul 2011 09:51:08 GMT

But week number is not starting from 1 and also it is not in sequence

Generating sequence number

Fri, 29 Jul 2011 10:02:37 GMT

what did you do?

Generating sequence number

Fri, 29 Jul 2011 11:10:08 GMT

Already I have CalendarWeek in my Calendar qvd...but start from W01 for each year

So I have used autonumber(CalendarWeek,1)....

Generating sequence number

Fri, 29 Jul 2011 12:00:52 GMT

OK,

autonumber gernerates for every new input a unique number. If the input is for ex. year + week in correct order it is working fine.

Check out my little example code in a new, empty application:

Load
    *,
    Year(MyDate)    AS MyYear,
    Week(MyDate)    As MyWeek,
    AutoNumber(Year(MyDate) & Week(MyDate))    AS MyWeekSerial
;
load
    date(today() +RecNo())    AS MyDate
AutoGenerate(400);