topic Re: first reload time in QlikView

first reload time

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

Hi All,

in my application i want to get the quarter details as below

if i am running the app for first time then i should get 2 previous quarters data if i am running that app next time it should show 3 previous Quarters data it should repeat up to 8 quarters

let’s say we are publishing this app in 2018 Q1 (i.e. Jan 2018) then the report will display data for 2017 Q3, 2017 Q4.

From there on, If reporting in 2018 Q2, we display data for - 2017 Q3, 2017 Q4, 2018 Q1.

To elaborate, if we are reporting on data in 2019 Q4, then we display data for quarters –2017 Q4, 2018 Q1, 2018 Q2, 2018 Q3, 2018 Q4, 2019 Q1, 2019 Q2, 2019 Q3 (rolling 8 quarters)

please help

Thanks,

hima.

Re: first reload time

Anil_Babu_Samineni — Mon, 06 Nov 2017 10:58:33 GMT

Perhaps this?

=Sum({<DateField = {"$(='>=' & Date(MonthStart(AddYears(Max(DateField), -2))) & '<=' & Date(MonthEnd(Max(DateField))))"}>} Measure)

Re: first reload time

himabinduch — Tue, 07 Nov 2017 10:03:26 GMT

Hi Anil,

it is not working for me

Re: first reload time

Anil_Babu_Samineni — Tue, 07 Nov 2017 10:44:03 GMT

Okay

Re: first reload time

himabinduch — Tue, 07 Nov 2017 10:46:00 GMT

Please let me know if you have any idea.

Re: first reload time

Anil_Babu_Samineni — Tue, 07 Nov 2017 10:50:27 GMT

Please provide sample and expected result on filter?

Re: first reload time

himabinduch — Tue, 07 Nov 2017 10:54:25 GMT

please go through my previous link so that you will have some idea.

Aggr Function