Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

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

Hello ,

We all have been trimming unnecessary spaces using trim functions . But i have a requirement where i want to load a column where i need to retain space (number of times space bar pressed , before actual data) .
I am not aware of function to do it  ?

Retaining Spaces.PNG

 

Thanks in advance . 

 

4 Replies
Highlighted
Specialist
Specialist

Hi Sunny Bhai ,  

Can this be achieved in qlik ?

@sunny_talwar 

 

 

Highlighted

Have you looked at this?

Verbatim 

Highlighted

Capture.png

Highlighted
Specialist
Specialist

Thank You Bhai ..