topic Increment by period in QlikView

Increment by period

Tue, 01 May 2012 14:24:41 GMT

Hi community,

Is there anyway in the script to increment a value by month and year? The first year is 2012 period 0. I want 2012, period 1 to be 1 and 2012, period 2 to be 2 etc. and 2013, period 1 to be 13 and 2013 period 2 to be 14.

Increment by period

CELAMBARASAN — Tue, 01 May 2012 15:00:12 GMT

Hi,

Try using autonumber function as

Load

autonumber(YearField & PeriodField) as PeriodNumber

From datasource;

Note: table should be order based on datefield.