Growth of previous RQTR vs current RQTR...

[jegadeesan]

Hi All,

Am trying to identify the growth between the previous year RQTR vs current year RQTR using below given script.  Am getting exact growth percentage while using the script in straight table but am not getting growth percentage in Combo chart using yearmonth as dimension...

((sum({$<DATAPERIOD={">=$(=date(addmonths(date#(max(DATAPERIOD),'YYYYMM'),-2),'YYYYMM'))<=$(=max(DATAPERIOD))"},LAB_DESC={'SSSS'}>}NVALUE)

-

sum({<DATAPERIOD={">=$(=date(addmonths(Addyears(date#(max(DATAPERIOD),'YYYYMM'),-1),-2),'YYYYMM'))<=$(=date(Addyears(date#(max(DATAPERIOD),'YYYYMM'),-1),'YYYYMM'))"},LAB_DESC={'SSSS'}>}NVALUE))

/

(sum({<DATAPERIOD={">=$(=date(addmonths(Addyears(date#(max(DATAPERIOD),'YYYYMM'),-1),-2),'YYYYMM'))<=$(=date(Addyears(date#(max(DATAPERIOD),'YYYYMM'),-1),'YYYYMM'))"},LAB_DESC={'SSSS'}>}NVALUE)))

*100

Regards,

Jegadeesan G

[Gysbert_Wassenaar]

Can you post a small Qlikview document that illustrates the problem?