GROWTH RATE

[sagaraperera]

Dear all

I want to calculate a growth rate for sale. my script have a 2014 and 2015 sale details of cluster wise. i want calculate given below formula

MY qvd  attached.

2015 GROSSTOT-2014 GROSSTOT/ 2014 GROSSTOT = GROWTH RATE

MY SCRIPT

LOAD BCOD,

     CLA_CODE,

     PRD_CODE ,

     POLICY_NO,

     REF_NO,

     MARKETING_DATE,

     MDATE,

     MONTH(MARKETING_DATE) AS MMONTH,

     YEAR,

     MONTH,

     NAME,

     ME_CODE,

     TRN_DATE,

     TRAN_YEAR,

     TRAN_MONTH,

     POL_PERIOD_FROM,

     SCCOD,

     CP,

     RS,

     TC,

     GROSSTOT,

     TYPE,

     N_R_NOS1,

     F_NOS2

FROM

G:\qlickviwe\Sales\SALES2015.QVD

(qvd);

DIRECTORY;

LOAD BCOD,

     CLA_CODE,

     PRD_CODE ,

     POLICY_NO,

     REF_NO,

     MARKETING_DATE,

     MDATE,

     MONTH(MARKETING_DATE) AS MMONTH,

     YEAR,

     MONTH,

     NAME,

     ME_CODE,

     TRN_DATE,

     TRAN_YEAR,

     TRAN_MONTH,

     POL_PERIOD_FROM,

     SCCOD,

     CP,

     RS,

     TC,

     GROSSTOT,

     TYPE,

     N_R_NOS1,

     F_NOS2

FROM

G:\qlickviwe\Sales\SALES2014.QVD

(qvd);

[arulsettu]

try this

(sum({<YEAR={$(=max(YEAR))}>}GROSSTOT)-sum({<YEAR={$(=max(YEAR)-1)}>}GROSSTOT))/sum({<YEAR={$(=max(YEAR))}>}GROSSTOT)

[gautik92]

Try this

(sum({<YEAR={$(=max(YEAR))},MonthID={$(=Max(MonthID))}>}GROSSTOT)-sum({<YEAR={$(=max(YEAR)-1),MonthID={$(=Max(MonthID))}>}GROSSTOT))/sum({<YEAR={$(=max(YEAR))}>}GROSSTOT)

[sagaraperera]

THANKS DEAR IT IS CORRECT

SAGARA

[arulsettu]

please mark it as correct if it is solve your problem

[sagaraperera]

how to mark as corect

[arulsettu]

below my answer there is a correct answer button with a green star clik it

[jagan]

Hi,

Try this  expression, you need to include TRN_DATE=,   TRAN_MONTH= in your expression otherwise whenever you select month  or date it will changes to the Month or date selected.

(sum({<TRN_DATE=,   TRAN_MONTH=,

TRAN_YEAR={$(=max(TRAN_YEAR))}>}GROSSTOT)-sum({<TRN_DATE=,   TRAN_MONTH=, TRAN_YEAR={$(=max(TRAN_YEAR)-1)}>}GROSSTOT))/sum({<TRN_DATE=,   TRAN_MONTH=, TRAN_YEAR={$(=max(TRAN_YEAR))}>}GROSSTOT)