topic Re: Rolling 24 months with diffrent logic in QlikView

Rolling 24 months with diffrent logic

Kushal_Chawda — Fri, 31 Jan 2014 10:28:42 GMT

Dear All,

I have requirement where I need to show previous 24 months data based on current month selection.

For eg. If I selected Year '2013' & Month 'Dec' it should display data from Dec- 2011 to Nov-2013.

I can achieve this using set analysis , but due to some requirement I need to do it from Script.

So In script I need to have data from Dec- 2011 to Nov-2013 for Dec-2013.

and from Nov- 2011 to Oct-2013 for Nov-2013

Any help will be appreciated to achieve this from Script.

Regrads,

Kush

Re: Rolling 24 months with diffrent logic

Anonymous — Fri, 31 Jan 2014 12:12:43 GMT

Hi Kushal,

Please find attached files,it may help you.

Re: Rolling 24 months with diffrent logic

Kushal_Chawda — Mon, 03 Feb 2014 04:19:23 GMT

Jatin,

logic works but in my actual scenario there is IDS for Particular month..

for eg.

ID MONTH AMOUNT

1 Dec-13 100

2 Dec-13 200

3 Dec-13 300

4 Jan-14 150

5 Jan-14 200

6 Jan-14 400

Re: Rolling 24 months with diffrent logic

tresB — Mon, 03 Feb 2014 05:00:56 GMT

You might have to slightly modify the code that Jatin Kolhe has suggested depending on your data. If you can't get around, please prepare your sample app and share.

Re: Re: Rolling 24 months with diffrent logic

Anonymous — Mon, 03 Feb 2014 06:57:23 GMT

Hi Kushal,

Please find attach files.

Re: Re: Re: Rolling 24 months with diffrent logic

Anonymous — Mon, 03 Feb 2014 12:11:32 GMT

Hi Kushal,

Please find attach files.

Re: Re: Re: Re: Rolling 24 months with diffrent logic

Anonymous — Tue, 04 Feb 2014 13:48:45 GMT

Hi Kushal,

Please find attached files.

Re: Rolling 24 months with diffrent logic

Tue, 04 Feb 2014 14:02:52 GMT

Kushai,

I created a doc : http://community.qlik.com/docs/DOC-4821

In fact, you create an Asof table that will change the cardinality between the selection and the data: to compute 24 months.

The doc contain some scripts (I was a newbie when I wrote it but it can help you)

Fabrice