Drop field

One or several QlikView fields can be dropped from the data model, and thus from memory, at any time during script execution, by means of a drop field statement.

Note: Both drop field and drop fields are allowed forms with no difference in effect. If no table is specified, the field will be dropped from all tables where it occurs.


Drop field fieldname [ , fieldname2 ...] [from tablename1 [ , tablename2 ...]]

Drop fields fieldname [ , fieldname2 ...] [from tablename1 [ , tablename2 ...]]


Drop field A;

Drop fields A,B;

Drop field A from X;

Drop fields A,B from X,Y;

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?