topic Re: I am implementing rolling three month dashboard . in QlikView

I am implementing rolling three month dashboard .

Tue, 26 Nov 2013 05:54:06 GMT

Hello Friends,

I am implementing Rolling 3 months procedure in my dashboard where my fiscal year is from April to March.

my date is [Posting Date] and i want to calculate rolling 3 month Amount .

What condition should i use..

Thanks and Regards.

er_mohit — Tue, 26 Nov 2013 06:03:39 GMT

See the attached file

er_mohit — Tue, 26 Nov 2013 06:08:07 GMT

You can use Farmula for expression side on the basis of date also used

like this

sum({<PostingDate = {">=$(=MonthStart(Max(PostingDate), -2))<=$(=MonthEnd(Max(PostingDate)))"},Year=,Month=>}Sale)

Tue, 26 Nov 2013 06:08:45 GMT

Hi Try This Set analysis hope it will help

=sum({<PostingDate={'>=$(Vrolling3)<=$(vMaxDate)'},month=,year=>}Amount)

Variables:

Vrolling3 : =Date(MonthStart(vMaxDate,-2),'DD/MM/YYYY')

vMaxDate : =Date(max(PostingDate),'DD/MM/YYYY')

Tue, 26 Nov 2013 07:21:10 GMT

Thanks All For Helping me out...