Home | SkillForge Blog | QlikView Quick Suggestions: Moving a Comma for Quick Editing

QlikView Quick Suggestions: Moving a Comma for Quick Editing

Business Intelligence, QlikView

Here is a simple and very straight forward suggestion when working in QlikView’s Script Editor.

When you are loading data from any source and your LOAD statement has a list of fields that you may want to shorten at some point; consider this simple suggestion.

The comma that divides the field values is found ate the end of the field name.

Script-editor

Consider moving the comma to the beginning of the next line and remove it from the end of the previous line.

Script-editor-comma-moved

Now if you find it necessary to remove a field or two or more from your table; just comment out that line in your script using a single line comment.

Script-editor-comma-moved-commented-out

No additional changes need to be made. Save the file and reload your script.

Need the field back…remove the comment, save, reload.

Life is good!