Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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