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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
Specialist
Specialist

Re: Way to retain Leading number of "spaces" from excel data while loading . If any ?

Hello Bhai , 

It seems this SET Verbatim = 1; , does not work in Qliksense .

It tried with above data only .

 

Retaining Spaces2.PNG

 Thank you 

1 Solution

Accepted Solutions
lorenzoconforti
Specialist II
Specialist II

one workaround is to replace spaces with chr(160); you can implement it as a calculated dimension

See attached

View solution in original post

4 Replies
shekhar_analyti
Specialist
Specialist
Author

qvf attached 

sunny_talwar

The spaces are retained, but not displayed.

shekhar_analyti
Specialist
Specialist
Author

Is there way to make them appear as is ?  

lorenzoconforti
Specialist II
Specialist II

one workaround is to replace spaces with chr(160); you can implement it as a calculated dimension

See attached