Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

A strange number formatting

Hello guys,

I need to convert a number into a 6-chars string keeping it on the right and filling the left side with blanks, so the number 12345 must be converted into ' 12345'...the number 1 into '     1'.

Is there a function to simply do it or have I to invent something never seen 'till today? 😁

Many thanks.

N.

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Repeat(' ',6-Len(Text(num))) & num

N.

View solution in original post

4 Replies
Highlighted
Contributor III
Contributor III

Repeat(' ',6-Len(Text(num))) & num

N.

View solution in original post

Highlighted
Digital Support
Digital Support

Hey Nick, I am going to mark the post with the expression as the solution, as I think that is what you were say, please correct me if I am wrong in that assumption, thanks for posting it!  You should be able to mark it yourself, just FYI, after you do the post, you can still use the Accept as Solution button on it to mark it for future reference.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
Contributor III
Contributor III

Hi Brett,

your assumption is right...I know the use of the "Accept as solution" button; I didn't use it because it seemed a bit strange  to me to post the question, the reply and auto-mark my solution as the right one!

Thank you so much.

N.

Highlighted
Digital Support
Digital Support

Yeah, no worries, marking things lets folks know what actually worked, so do not hesitate to mark you own if you are explaining what you did to get things working...  Thanks for the follow-up, much appreciated!

Cheers,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.