Using group by problam

[#1]

We have one transaction table containing 80 laces record it's will hang when we use group by.

And take lot of memory .

My script are.

IntlAggSector:
Load
PAX_INFO_ID,
FLIGHT_ID,
FIRSTVALUE(DEPARTURE_AIRPORT) & ' - ' & LASTVALUE(ARRIVAL_AIRPORT) AS SECTOR
FROM D:\Qlikview\Air\QVD\Copy_AIR_MIS_FULL.qvd (qvd)
GROUP BY PAX_INFO_ID, FLIGHT_ID
ORDER BY PAX_INFO_ID, FLIGHT_ID, SEGMENT_ID ASC;

please help me urgent basic

Regards

Ashish Srivastava

[#2]

Hi

Can't you move the group by into the DB query or into a separate qvw producing only the qvd files and have a directly loadable QVD file without any further logic applied? This QVD will then also load super-fast.

Regards

Juerg

[#3]

we make separate qvw file lode qvd and then apply logic