Qlik Community

Qlik Sense App Development

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

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
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

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

qvf attached 

Highlighted

The spaces are retained, but not displayed.

Highlighted
Specialist
Specialist

Is there way to make them appear as is ?  

Highlighted
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