Need help on to maintain a history data

[#1]

Dear Guru's

As I have request that I need to store the data on daily basis like

1) I have developed a application in Qlikview source data is AS/400 using that I created a stright table which contains

          Today, Count of Invoice and Sum of Rupees

2) What I need is I would like to store these three columns in a Excel or QVD which is used as history data as a input to another

     QVW file.

Is is possible, can anybody help me

Regards

Joe

[vijay_iitkgp]

ODBC CONNECT TO AS400 (XUserId is NMTLEB, XPassword is NMTTPB);

Trend:

SQL SELECT

CORP as Client,

SUB as  Subsidary,

LOC as  Location,

Count(PRON) as Invcount,

Sum(RUPEE) as Amount

FROM S104F31D.Data

Where CORP =180

Group BY

CORP,SUB,LOC

;

Store Trend into Test.qvd;

Hope this will work.

[#3]

Dear Vijay,

It works fine, thanks a lot

And now I would like to add one more expression column which is not working as in the below.

1) Count(if([Aged]='2/1-30 DAYS',[PRON])) + Count(if([Aged]='3/31-60 DAYS',[PRON]))+ Count(if([Aged]='4/61-90       DAYS',[PRON]))+ Count(if([Aged]='5/90+DAYS',[PRON])).

2) Aged is column which is not availalbe in the database and its a expression manually created in the straight           table.

2/1-30 DAYS

3/31-60 DAYS

4/61-90 DAYS

5/90+DAYS

3) How to add in the select statment for the above requirements.. Please advise