Calculating Data on Date time for future months.

[Anonymous]

Dear All ,

I need to calculate sum of data against date and Acounts such that for a particular month my output should be sum of the data residing in the months greater than selected months. (Needed In Scrip )

Data:

Month Acnt Data

Jan a1 100

Feb a1 101

Mar a1 102

Apr a1 103

Output :

Month Acnt Output

Jan a1 306

Feb a1 205

Mar a1 103

Apr a1 0

NOTE: I am able to achieve the same in front end using SET but i need the same in script level.

Kindly help

Regards

Ankit Tiwari

[Anonymous]

Hi,,

Sor[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/4774.Query.zip:550:0]ry for late reply,

This is working alright for only year months. I need futuristic amount for every Document (polnum) and other dimentions.

But as soon as i include polnum and other dimention data changes.


Kindly see if u can do anything on this.


Attached the application, how the data is needed .


Regards

[tresesco]

i can't go with application right now. let me try otherwise. What is your key in this table ?

Regards, tresesco

[Anonymous]

Hi,

The data is needed against these dimentions.

where POLNUM is the document number.

the data against every POLNUM has to be calculated such that under one month say( July 2010) the sum of future months of POLNUM data is to be calculated and then displayed against date.



LOAD
Data,
BATCBRN,
POLNUM,
RECNUM,
SUBCLASSCODE,
SACSCODE01,
YearMonth,
Date1
FROM TAB1.qvd(qvd);

Regards

Ankit Tiwari

[tresesco]

let me know what output you expect :

POLNUM	Data	Dim1	Dim2	Date	YearMonth	OutPut
1	10			1/1/11	Jan 2011	?
2	10			2/1/11	Jan 2011	?
3	10			3/3/11	Mar 2011	?
4	10			4/3/11	Mar 2011	?
5	10			10/10/11	Oct 2011	?
6	50			11/10/11	Oct 2011	?

[Anonymous]

Kindly find the data in two tabs inside excel sheet.

The first sheet has the data for all years while the second has only bifercation data for july 2010.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/6332.Needed-data.zip:550:0]

Warm Regards

Ankit Tiwari

[tresesco]

Hi, Still not clear to me(pardon my bad apprehension skill !). can you please give me a case, as i structured in my earlier post? it could have been easier if you would fill the "?????" in the above chart. it would help me understand the logic behind your aggregation.