Skip to main content
Drop field

ON THIS PAGE

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.

Information noteBoth 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.

Syntax:  

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

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

Examples:  

Drop field A;

Drop fields A,B;

Drop field A from X;

Drop fields A,B from X,Y;

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com