topic Rolling quarters in QlikView

Rolling quarters

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

Hi Dada,

please find the attachment need rolling 8 quarters.

Re: Rolling quarters

Chanty4u — Thu, 01 Mar 2018 06:23:36 GMT

can you share sample excel data and expected output ?

Re: Rolling quarters

himabinduch — Thu, 01 Mar 2018 06:46:00 GMT

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.

Re: Rolling quarters

prma7799 — Thu, 01 Mar 2018 06:51:47 GMT

Have you check this?

Set Expression - For Rolling Quarters | Qlik Community

Re: Rolling quarters

himabinduch — Thu, 01 Mar 2018 07:10:40 GMT

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()))