rolling months not working properly

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

Hi,

I have used the below logic to roll back to 12 months.

example:

But when i select like Mar2018 it is roll back to 12 months.

But when i select Feb2018 a few months data were missing.

Logic Used:

if(isnull(Sum({$<[Month Abbr]=, Year=, [Month Year]=,[Quarter Name]=, [Calendar Date]={"$(=date(AddMonths(monthend(floor(Max([Calendar Date]))),-5),'DD-MMM-YYYY'))"}>}[# AR Open])),null(),

Sum({$<[Month Abbr]=, Year=,[Month Year]=, [Quarter Name]=, [Calendar Date]={"$(=date(AddMonths(monthend(floor(Max([Calendar Date]))),-5),'DD-MMM-YYYY'))"}, [Age Days 90 Flag] = {'Y'},[Monthly Snapshot Flag]= {1},[Conformed Status] -= {'Monitoring*', 'Effectiveness Check'}>}[# AR Open])/

Sum({$<[Month Abbr]=, Year=,[Month Year]=, [Quarter Name]=,[Calendar Date]={"$(=date(AddMonths(monthend(floor(Max([Calendar Date]))),-5),'DD-MMM-YYYY'))"},[Monthly Snapshot Flag]= {1},[Conformed Status] -= {'Monitoring*', 'Effectiveness Check'}>}[# AR Open]))*100

Thanks..

Re: rolling months not working properly

agomes1971 — Thu, 02 Aug 2018 09:15:15 GMT

Hi,

please read this:

Set Analysis for Rolling Periods

HTH

André Gomes

Re: rolling months not working properly

ChennaiahNallani — Thu, 02 Aug 2018 09:21:57 GMT

share sample qvf

topic Re: rolling months not working properly in QlikView

rolling months not working properly

Re: rolling months not working properly

Re: rolling months not working properly