Rolling 8 Quarters

[himabinduch]

Hi Experts,

i have three fields

YearQuarter  derived from created date),

YearQuarter_shipped (derived from shipped date),

now i need rolling quarters for this.

i have taken YearQuarter and YearQuarter_shipped as dimensions and my expression is as below to get rolling quarters.

=RangeSum(Before(count({<SHIPPED_DATE={'>=$(=QuarterStart(max(SHIPPED_DATE), -8))<=$(=QuarterEnd(max(SHIPPED_DATE), 0))'},SHIPPED_DATE={'*'}>}DISTINCT ITEM))/

(count(TOTAL <YearQuarter>{$<CREATION_DATE={'*'},CREATION_DATE={'>=$(=QuarterStart(max(CREATION_DATE), -8))<=$(=QuarterEnd(max(CREATION_DATE), 0))'}>}DISTINCT ITEM)))

Thanks,

Hima.

[Anil_Babu_Samineni]

I am confused, Is there any Question?

[shiveshsingh]

What's the error you getting?

[himabinduch]

i am getting Zero values for everything not getting any rolling quarters

[Anil_Babu_Samineni]

Can you do this for now, Whether values returning or not? This is for last 2 years data. If none of them not working, I would suggest to share sample

=Count({<SHIPPED_DATE={">=$(=AddYears(max(SHIPPED_DATE), -2))<=$(=max(SHIPPED_DATE))"}>}DISTINCT ITEM)/

Count(TOTAL <YearQuarter> {$<CREATION_DATE={">=$(=AddYears(max(SHIPPED_DATE), -2))<=$(=max(SHIPPED_DATE))"}>}DISTINCT ITEM)

OR

=RangeSum(Before(count({<SHIPPED_DATE={">=$(=QuarterStart(max(SHIPPED_DATE), -8))<=$(=QuarterEnd(max(SHIPPED_DATE), 0))"},SHIPPED_DATE={'*'}>}DISTINCT ITEM))/

(count(TOTAL <YearQuarter>{$<CREATION_DATE={'*'},CREATION_DATE={">=$(=QuarterStart(max(CREATION_DATE), -8))<=$(=QuarterEnd(max(CREATION_DATE), 0))"}>}DISTINCT ITEM)))

[himabinduch]

Hi Anil,

i am not getting proper data. could please find my sample application in below link

so the you will get exactly what i required.

https://community.qlik.com/thread/291517?sr=inbox&ru=171708