topic Re: Help to create logic in QlikView

Help to create logic

Kushal_Chawda — Thu, 25 Jul 2013 09:45:04 GMT

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?

Re: Help to create logic

jvitantonio — Thu, 25 Jul 2013 10:28:40 GMT

Hi, is this what you need?

Re: Help to create logic

qlikpahadi07 — Thu, 25 Jul 2013 21:13:09 GMT

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

Re: Help to create logic

Kushal_Chawda — Fri, 26 Jul 2013 06:50:32 GMT

Hi Rohit,

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

Re: Help to create logic

Kushal_Chawda — Fri, 26 Jul 2013 06:54:08 GMT

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