Need help in optimization

[Anonymous]

Hi,

I have a table with 6,778,904 records and from that i need to take the maximum and minimum date. I used the following code. But it is taking more time to complete.

CalTemp:

LOAD

max(SERVICEDATE) as MaxDate,

min(SERVICEDATE) as MinDate

Resident COST;

I am loading the COST from a qvd file. Any idea on how to optimize this?

Thanks

[sunny_talwar · Accepted solution]

Just what you need:

Better Calendar Scripts | Qlikview Cookbook

[Anonymous]

Yeah, it works perfectly. Thanks for the reference