topic Re: Create field Year-1 in QlikView

Create field Year-1

christophebrault — Thu, 13 Jun 2013 08:43:34 GMT

Hi,

In the script, i have a table with the fields :

Date, CD_SOCIETY,CD_ENTITY,CD_PRODUT, VOLUME

I want to add a field VOLUME_N_1 wich is the value of VOLUME for last year using the field VOLUME.

How can i do this in the script please ?

Thanks

Anonymous — Thu, 13 Jun 2013 09:43:39 GMT

Do you mean that records in this year have an additional field that shows the total volume for last year for all products etc ?

Jonathan

Thu, 13 Jun 2013 09:58:44 GMT

IF(Max(year(Date(Date,'YYYY'))) >0, VOLUME) AS VOLUME_N_1

Thu, 13 Jun 2013 10:07:25 GMT

TRY THIS

LOAD *,

IF(YEAR=Max(YEAR), VOLUME) AS VOLUME_N_1;

LOAD

Date,

CD_SOCIETY,

CD_ENTITY,

CD_PRODUT,

VOLUME,

year(Date(Date)) AS YEAR

FROM TABLE;