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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

how to remove non key field and script variable in qlikview

how to remove non key field and script variable in qlikview

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Dropping a field can be done with a Drop Field MyField statement.

A variable can be dropped if it was created in the script and it is set to null before the script ends with a line like SET vMyVar=;


talk is cheap, supply exceeds demand
MK_QSL
MVP
MVP

Drop Field FieldName from TableName;

To Drop a variable write below at script end

SET vVariableName = NULL();

and delete the variable from

Setting >> Variable Overview