Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

DROP FIELD - Recalculation

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 ?

1 Reply
johnw
Champion III
Champion III

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
...
;