topic Re: cumulative in QlikView

cumulative

sagaraperera — Thu, 16 Apr 2015 10:22:49 GMT

I want to cumulative value it should be a related to month value eg feb 2015 value related to jan 15 + feb 15. i have a month field it was select to month of feb cumulative value should be Shawn on only jan and feb15

can i help me

sagara

Re: cumulative

sunny_talwar — Thu, 16 Apr 2015 10:49:59 GMT

You can use a combination of Aggregate, RangeSum and above functions to achieve what you are trying to do. This is the best I can help you with amount of information you have provided here.

Best,

Sunny

Re: cumulative

sagaraperera — Thu, 16 Apr 2015 11:14:23 GMT

When I need a month of compensation to the value of the current value of the previous several months plus CUMULATIVE get appreciated.

Re: cumulative

sagaraperera — Thu, 16 Apr 2015 11:15:45 GMT

When I need a month of compensation to the value of the current value of the previous several months plus CUMULATIVE get appreciated.

sagara

Re: cumulative

sunny_talwar — Thu, 16 Apr 2015 11:20:26 GMT

Would you be able to provide sample data or application to work with?

Best,

Sunny

Re: cumulative

sagaraperera — Thu, 16 Apr 2015 11:27:04 GMT

BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

MONM,

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

[..\..\qlickviwe\P&L\P&LBUDDATA2011_2014.QVD]

(qvd);