Last Year cumulative value

sagaraperera — Fri, 18 Dec 2015 02:55:53 GMT

Dear All,

I am get a last year current month vale use this expression sum( {$<TRAN_YEAR = {"$(=Only([TRAN_YEAR]-1))"}>} [Actual]) This expression is hundred percent ok. but this expression Shaw only month value. I want cumulative value of last year. Please help me

Thanks

Sagara

Re: Last Year cumulative value

tamilarasu — Fri, 18 Dec 2015 02:58:26 GMT

Could you post your your TRAN_YEAR value.?

Re: Last Year cumulative value

sagaraperera — Fri, 18 Dec 2015 03:06:54 GMT

My Script

LOAD BCOD,

MONTH,

YEAR,

MONM,

//NOTES,

//NOTE_DESC,

//AC_GP,

// DATE(Floor(MonthEnd(MakeDate(YEAR,MONTH)))) as TRAN_DATE,

DATE(Floor(MonthStart(MakeDate(YEAR,MONTH)))) as TRAN_DATE,

// DATE(MonthEnd(Date#([YEAR] &'-'& [MONTH],'YYYY-MM')),'DD MMM YYYY')AS [TRAN_DATE],

MONTH2,

CLA_CODE,

GROSS_PREMIUM,

SRCC_PREMIUM,

REINSURANCE_FUND,

FOREIGN_COMPANIES,

CEEDED_PREMIUM,

NRP,

UPR_CHARGE,

NEP,

SRCC_TC_COMMISSION,

FOREIGN_CO_COMMISSION,

COMMISSION_INCOME,

NET_REVENUE,

GROSS_CLAIMS,

CLAIMS_RES_FUND,

EXGRATIA_CLIMS_RES_FUND,

CLAIMS_PROCESSING_EXPENSES,

LEGAL_FEES,

RI_RECOVERIES_RI_FUND,

RI_RECOVERIES_SRCC_TC,

RI_RECOVERIES_FOREIGN,

SALVAGE_RECOVERIES,

NET_CLAIMS,

COMMISSION_EXPENSES,

PRODUCTION_BONUS,

DAC_CHARGE,

ACQUISITION_COST,

GROSS_PROFIT,

STAFF_EXPENSES,

ADMIN_EXPENSES,

SELLING_EXPENSES,

FINANCIAL_EXPENSES,

DEPRICIATION_EXPENSES,

MANAGEMENT_EXPENSES,

INV_INCOME_EXT,

INV_INCOME_INT,

OTHER_INCOME_EXT,

OTHER_INCOME_INT,

INV_OTHER_INCOME,

NET_PROFIT

FROM

I USE CAL

Trandatecalender:

LOAD

DAY(TRAN_DATE) AS TRAN_DAY,

DATE(TRAN_DATE) AS TRAN_DATE,

DATE(monthstart(TRAN_DATE), 'MM-YYYY') as MONTH_YEAR,

WEEK(TRAN_DATE) AS TRAN_WEEK,

YEAR(TRAN_DATE) AS TRAN_YEAR,

MONTH(TRAN_DATE) AS TRAN_MONTH,

MONTH(TRAN_DATE) &'-'& WEEK(TRAN_DATE) AS MONTH_WEEK;

LOAD DATE (TRAN_MINDATE + ITERNO() -1) AS TRAN_DATE WHILE (TRAN_MINDATE + ITERNO () -1) <= NUM (TRAN_MAXDATE);

LOAD

MIN(TRAN_DATE) AS TRAN_MINDATE,

MAX(TRAN_DATE) AS TRAN_MAXDATE

RESIDENT PL;

Re: Last Year cumulative value

tamilarasu — Fri, 18 Dec 2015 03:20:19 GMT

Try,

sum( {$<TRAN_YEAR = {"$(=Max(Year([TRAN_YEAR]))-1)"}>} [Actual])

Re: Last Year cumulative value

Chanty4u — Fri, 18 Dec 2015 04:33:38 GMT

hi,

chk below thread

Set Analysis for certain Point in Time

topic Re: Last Year cumulative value in QlikView

Last Year cumulative value

Re: Last Year cumulative value

Re: Last Year cumulative value

Re: Last Year cumulative value

Re: Last Year cumulative value