I have been analyzing ways for lowering incremental loading times, and it seems that the above is so slow, that I might even opt for full load from the DB source and not from QVD.
? Thanks, J
May be use the fieldvalue method laid out in this thread:
Better Calendar Scripts | Qlikview Cookbook
So if I have the following 10 million rows QVD - Orders.qvd
Instead of using Max, I should be doing the following?
Max(FieldValue('OrderID',RECNO())) as MaxOrderID
So where am I picking it from? - Shouldn't I have a 'Resident Orders' statement?
You don't need Resident Load, that part of taken care by AutoGenerate and this is what makes it quick. It will look at the distinct set of values within OrderID field to bring the highest value.
That's right. I just realized it.
Thanks very much!
Retrieving data ...