Discussion board where members can get started with QlikView.
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.
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.
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).
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.
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?
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.
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.