topic Using group by problam in QlikView

Using group by problam

Tue, 25 May 2010 07:21:36 GMT

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

Using group by problam

Tue, 25 May 2010 12:57:21 GMT

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

Using group by problam

Wed, 26 May 2010 06:21:55 GMT

we make separate qvw file lode qvd and then apply logic