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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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
...
;