topic Re: CUMULATIVE in QlikView

CUMULATIVE

sagaraperera — Wed, 10 Jun 2015 09:47:05 GMT

Dear all

please advise me as how to get the cumulative automatic updated when the month table is selected Eg; When the seletion month is may the cumulative figure should total up the value of jan.feb,mar,april and may.

i give below the my script that was above by me in this connection.

CrossTable(DESCRIPTION, BUDGET, 6)

LOAD 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);

Directory;

CrossTable(DESCRIPTION, BUDGET, 6)

LOAD 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&LBUDDATA2015.QVD]

(qvd);

sagara

Re: CUMULATIVE

Gysbert_Wassenaar — Wed, 10 Jun 2015 13:32:10 GMT

Try something like sum( {<MONTH={"<=$(=max(MONTH))"}>} ACTUAL)

Re: CUMULATIVE

sagaraperera — Thu, 11 Jun 2015 03:07:09 GMT

Dear Mr.Gysbert Wassenaar

Thanks your expression is 100% work.thanks dear thanks

sagara

Re: CUMULATIVE

sagaraperera — Thu, 11 Jun 2015 03:27:04 GMT

DEAR MR.GYSBERT

CAN YOU HELP SOLVE THIS ISSUE

please advise me as how to get the PREVIOUS MONTH WITH CURRENT MONTH automatic updated when the month table is selected Eg; When the seletion month is may the PREVIOUS figure should up the value of APRIL.

i give below the my script that was above by me in this connection.

EG;

I WANT TO THIS TABLE

DESCRIPTION CURRENT MONTH PREVIOUS MONTH

ACTUAL ACTUAL

GROSS PREMIUM 10000 5000

MY SCRIPT GIVEN BELOW

CrossTable(DESCRIPTION, BUDGET, 6)

LOAD 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);