Rolling quarters

[himabinduch]

Hi Dada,

please find the attachment need rolling 8 quarters.

[Chanty4u]

can you share sample excel data and expected output ?

[himabinduch]

Hi Chanty,

i don't  have excel for this but i can explain what exactly i need .

there is a field called activity period and reporting period in the given attachment.

if i click on 2014Q1 of activity period it should display 8 rolling quarters in Reporting period from 2013Q3 2013Q4 2014Q1 2014Q2 2014 Q3  2014Q4 2015Q1 2015Q2. like this i need

thanks in advance,

Hima.

[prma7799]

Have you  check this?

Set Expression - For Rolling Quarters | Qlik Community

[himabinduch]

Hi PM,

this will not work in my case. could you please find my expression below

RangeSum(Before((count({$<SHIPPED_DATE={'*'}>}DISTINCT ITEM))/(count(TOTAL <YearQuarter>{$<CREATION_DATE={'*'} >}DISTINCT ITEM)), 0, ColumnNo()))