Help to create logic

[Kushal_Chawda]

Dear All,

I have attched the data & application.

In chart I am showing previous  3rd month amount for Monthyear.

When I select 2012 I am getting the correct data as this is the starting year.

But when I select year 2013 I am not getting the data for Apr-2013 May-2013,Jun-2013 (actually for May-2013 it should get the amount for previous 3rd month i.e Feb 2012.. similarly for Apr-2013 should show Amount of Jan 2012)

But here I am not able to buid the logic for the same

Can anyone help me to solve this issue?

[jvitantonio]

Hi, is this what you need?

[qlikpahadi07]

Hi Kush,

May be this will be helpful

I have few doubts like it seems you are using all Bucket Values

Bucket={'1-29','30-59','60-89','90-119','120-149','150-179','180-209','210+','Current'}

also July 2013 is not in Date check it's may be incorrect.

I have did few changes from Backend too as I was not able to get it from Front end only

find the attachmnt

[Kushal_Chawda · Accepted solution]

Hi Rohit,

That was very helpful.. Got some idea from this. Finally done some changes & here is the solution attched.

[Kushal_Chawda]

hi qlikuser14,

actually it is not which i am looking for but it will be a very good example in some senario.

Thanks for the help