Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Rolling Months

Hi!

Plz I need some help!!!

I have attached a sample app below which contains some data.

If I am looking at May 2010 data (i.e. 15 ) then this means that it is the data is uptill May (i.e. Apr and May).

Now i want a chart like the attached one.

Suppose i have Clicked the dimension Monthyear as 'Apr 2011'  Then the value for this is calculated as: May2010+Jun 2010+......Apr2011.

My X axis will contain last 12 Month from the selected dimension Value.

15 Replies
Not applicable

Re: Rolling Months

Hi,

Have a look at the attached demo application which has been created by John Witherspoon


This application explains about the functionality of Rolling 12 months, Qtr and YTD in detail.

Hope this helps you.

- Sridhar

Not applicable

Rolling Months

Thanks for the help!

But I don't want this.

My actual problem is How to convert' Upto data' into 'for the Month data'.

if  Uptill May 2010 data (i.e. 15 (April + may)) and April 2010 data is 10.

Then this means that April data is 10. May data is 5 (In month may Data is 5 only).

pat_agen
Not applicable

Rolling Months

hi,

You want to isolate each month's total from the running total in your original dataset. is that correct?

put this preceeding load before your load inline statement.

load

Monthyear,

Uptodata,

if(left(Monthyear,3)='Apr',Uptodata,Uptodata - previous(Uptodata)) as MonthData;

From your data it looks as if your accumulated total resets itself in April so we test for April.

MonthData shoudl give you what you require.

have I understood your request correctly?

rahulgupta
Not applicable

Re: Rolling Months

Hey Hi,

Kindly find the attached file.

Regards

Not applicable

Re: Rolling Months

Thanks a lot  Pat & Rahul !!!!!.

  Its working perfectly in the sample data which I have uploaded.

Hope it works in my Main application also.!!!

can u solve the second issue also.....The chart that I want to prepare.

pat_agen
Not applicable

Rolling Months

hi,

could you give some more clarification about your requirements.

Your initial post was not very clear and Sridhar gave you the reply I was thinking about. It wasn't till you replied to that mail that I understood you requirement. Same goes for the graph - I don't see what you are trying for.

Not applicable

Rolling Months

i have a code for what I want...

let me try myself....

Thanks to all for there help!!!

Not applicable

Rolling Months

i am attaching a chart.

May be now its clear.

Not applicable

Re: Rolling Months

i am attaching a chart.

May be now its clear.