Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

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

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
Highlighted
Specialist
Specialist

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

qvf attached 

Highlighted

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

The spaces are retained, but not displayed.

Highlighted
Specialist
Specialist

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

Is there way to make them appear as is ?  

Highlighted
Specialist II
Specialist II

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

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

See attached

View solution in original post