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
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 UsWelcome Guest
Installed Qlik Products
My Environments
Log your environments to ensure faster and more targeted troubleshooting.
View Available Licenses
My Licenses
Understand your licenses to help you maximize your experience.
Knowledge
Trailing and succeeding blank spaces are removed from data during load
Article Number: 000003440 | Last Modified: 2018/10/18Description
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.
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;
Get Answers
Find Answers
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.