Qlik® | Support Portal
Quick Links
Contact
Find Answers

Join Qlik Community

Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.

Join Us
Get Support

Have a Question?

Search Qlik's Support knowledge database or request assisted support for your highly complex issues.

Submit a Case
Talk with a Representative

Critical Issues

Experiencing a serious product issue? Please Contact us by phone. Click here to view phone numbers and hours by region.

Contact Us
My Account
Welcome Guest
×
Knowledge

Trailing and succeeding blank spaces are removed from data during load

Article Number: 000003440 | Last Modified: 2018/10/18

Description

Trailing and succeeding blank spaces (ASCII character 32) are removed from data loaded into QlikView.

Cause

QlikView automatically strips data of preceding and succeeding blank spaces by default during load. This behavior is controlled by the system variable verbatim.

See also: SET Verbatim has no effect on Table and Filter pane








Verbatim:
Word for word; in exactly the same words as were used originally.
- I have copied his speech and here it is, verbatim.

Resolution

To avoid QlikView stripping imported data from leading and trailing blank spaces the variable verbatim should be set to 1.


Example:
set Verbatim = 1;

Was this content helpful?

   

Get Answers

Find Answers

Qlik Community

Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.

Join Us
Get Support

Have a Question?

Search Qlik's Support Knowledge database or request assisted support for highly complex issues.

Submit a case
Talk with a Representative

Critical Issues

Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.