topic Re: A strange number formatting in QlikView

A strange number formatting

NickP_DF — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: A strange number formatting

NickP_DF — Mon, 09 Dec 2019 19:53:29 GMT

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

Re: A strange number formatting

Brett_Bleess — Tue, 17 Dec 2019 18:50:20 GMT

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

Re: A strange number formatting

NickP_DF — Fri, 20 Dec 2019 17:51:29 GMT

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.

Re: A strange number formatting

Brett_Bleess — Mon, 23 Dec 2019 14:12:22 GMT

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