Sum maximum date

[#1]

Hi,

My data is like that

5-Oct-10	215
5-Oct-10	1,143
6-Oct-10	1,158
7-Oct-10	1,103
8-Oct-10	1,069
9-Oct-10	1,099
10-Oct-10	974
11-Oct-10	1,123
12-Oct-10	1,069
12-Oct-10	974
12-Oct-10	951
12-Oct-10	154
12-Oct-10	456
12-Oct-10	544
12-Oct-10	265

I want to calculate just maximum date like

10/5/2010	215
10/5/2010	1143
10/6/2010	1158
10/7/2010	1103
10/8/2010	1069
10/9/2010	1099
10/10/2010	974
10/11/2010	1123
10/12/2010	4413

Is it possible in qlikview with out using loading multiple this is dummy data we have more that 14 million records and it is very hard to reload this.

[vivientexier]

LOAD

  Date,

  Max(Sales) as Sales

From ...

Group By Date

;

[CELAMBARASAN]

I dont get the word "loading multiple". you could probably use Resident load once it is loaded.

Could you please explain if i missed anything.

[#4]

Adhimulam,

I dont want to load this multiple of time.

due to no of records we want to load just one time rather then Load first and get maximum date and load again to get our desired result.

[#5]

Texier,

If you know the function of group by it will sum all dates.

And we want to sum on highest  value of dates not on any other date

[#6]

Try this

Load *,

Date,

sum(sales) as Sale

Resident Table A

Group by Date;

[#7]

This works:

Data:

LOAD Date,
Sale
FROM

(biff, embedded labels, table is [Sheet1$]);

NoConcatenate

A:
Load Date,
Sum(Sale) as Sale Resident Data
Group by Date;

Drop Table Data;

[DavidFoster1]

I would suggest looking at:

IF(DATE=MAX(DATE),SUM(SALES)