DROP FIELD - Recalculation

Thu, 03 Jun 2010 18:48:14 GMT

in my script i run a series of DROP FIELD commands, in an effort to remove the unused fields, thus reducing the size of the QVW file.

what i am finding is that after it runs each DROP FIELD command, it seems to take time (probably to recalculate), and for bigger QVWs, what i might gain in size, i more than lose in response time.

is there a way to drop these fileds, but not calculate until after all of the fields were dropped, so as not to take such a large hit ?

any suggestions ?

DROP FIELD - Recalculation

johnw — Thu, 03 Jun 2010 20:14:55 GMT

If you aren't already doing so, it's possible that if you drop everything in a single statement, QlikView will drop all the fields, then do whatever other maintenance tasks it's doing.

DROP FIELDS
Field1
,Field2
,Field3
...
;

topic DROP FIELD - Recalculation in QlikView

DROP FIELD - Recalculation

DROP FIELD - Recalculation