topic Re: CURRENT MONTH WITH PREVIOUS MONTH in QlikView

CURRENT MONTH WITH PREVIOUS MONTH

sagaraperera — Thu, 11 Jun 2015 03:25:45 GMT

Dear all

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

Re: CURRENT MONTH WITH PREVIOUS MONTH

arulsettu — Thu, 11 Jun 2015 03:52:07 GMT

try this

current month - sum({<MONTH={$(=max(MONTH))}>GROSS_PREMIUM)

previous month - sum({<MONTH={$(=max(MONTH)-1)}>GROSS_PREMIUM)

Re: CURRENT MONTH WITH PREVIOUS MONTH

Thu, 11 Jun 2015 05:54:55 GMT

Hi,

Please try the code below:

For current month=Sum({<Month={$(=Date(Date#(Max(Month),'MM'),'MMM'))}>}GROSS_PREMIUM)

For previous month=Sum({<Month={$(=Date(Date#(Max(Month),'MM')-1,'MMM'))}>}GROSS_PREMIUM)

If no month is selected ,the max last month is taken by default.

Regards,

Jemimah

Re: CURRENT MONTH WITH PREVIOUS MONTH

sagaraperera — Thu, 11 Jun 2015 06:04:30 GMT

THANKS YOUR RESPONSE BUT USING ABOVE Sum({<Month={$(=Date(Date#(Max(Month),'MM')-1,'MMM'))}>}GROSS_PREMIUM) CODE SHOW ON CURRENT MONTH PLEASE HELP I WANT TO PREVIOUS MONTH DATA

SAGARA

Re: CURRENT MONTH WITH PREVIOUS MONTH

sagaraperera — Thu, 11 Jun 2015 06:04:48 GMT

THANKS YOUR RESPONSE BUT USING ABOVE sum({<MONTH={$(=max(MONTH)-1)}>GROSS_PREMIUM)CODE SHOW ON CURRENT MONTH PLEASE HELP I WANT TO PREVIOUS MONTH DATA

SAGARA

Re: CURRENT MONTH WITH PREVIOUS MONTH

Thu, 11 Jun 2015 06:08:28 GMT

Hi,

Could you please upload a sample qvw file.

Re: CURRENT MONTH WITH PREVIOUS MONTH

sagaraperera — Thu, 11 Jun 2015 06:51:04 GMT

MY SCRIPT

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

Re: CURRENT MONTH WITH PREVIOUS MONTH

Thu, 11 Jun 2015 06:58:12 GMT

hi,

I mean could you provide sample data?

Re: CURRENT MONTH WITH PREVIOUS MONTH

sagaraperera — Thu, 11 Jun 2015 07:24:38 GMT

Thanks dear it is difficult

sagara