Growth of previous RQTR vs current RQTR...

jegadeesan — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Growth of previous RQTR vs current RQTR...

Gysbert_Wassenaar — Wed, 21 Dec 2016 13:16:43 GMT

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

topic Re: Growth of previous RQTR vs current RQTR... in QlikView

Growth of previous RQTR vs current RQTR...

Re: Growth of previous RQTR vs current RQTR...