topic Re: Blank space format problem in QlikView

Blank space format problem

henrikalmen — Thu, 09 Apr 2015 09:12:29 GMT

I have a strange problem. If for example I want to format a number value like num(4711, '# ##0') the output becomes 4711 ##0. But if I open up an object properties window, go to number tab and mark integer and then I copy the format pattern displayed (# ##0) I can paste this format pattern into my formula and the result is 4 711 as expected. My manually typed blank space seems different than the blank space that I've copied! (Copying the blank space is enough, I can type the #-symbols and the zero manually.)

It's kind of absurd and I'm attaching a qvw with a simple text box illustrating this, and a small load script that illustrates that it happens there as well.

I don't understand why this is happening, do you?

Re: Blank space format problem

pokassov — Thu, 09 Apr 2015 09:20:04 GMT

Hi!

I've used function ord() for both "blank spaces".

It looks like there are different kinds of blank.

Re: Blank space format problem

robert_mika — Thu, 09 Apr 2015 09:21:48 GMT

This is not a space

This is no-break space

ANSI code 160

Re: Blank space format problem

henrikalmen — Thu, 09 Apr 2015 09:25:09 GMT

Oh! But do you mean that it should be a no-break space instead of the ordinary space that I have written? Or do you mean that my spacebar for some reason produces no-break space?

Re: Blank space format problem

PrashantSangle — Thu, 09 Apr 2015 09:26:34 GMT

Hi,

in Load script change set ThousandSep=' ';

It will work

Regards

Re: Blank space format problem

henrikalmen — Thu, 09 Apr 2015 09:28:21 GMT

My last question was unnecessary, I can of course see for myself that my spacebar works as intended but I did not know that I should be using a non breaking space in thsi situation. Thank you for your fast replies!

Re: Blank space format problem

robert_mika — Thu, 09 Apr 2015 09:29:51 GMT

The first.

Your spacebar produce 32 not 160.

Fallow max advice.

Re: Blank space format problem

henrikalmen — Thu, 09 Apr 2015 09:30:13 GMT

Aha, that's where the non breaking space was defined. Thank you! Is there a reason..? Is it better to use non breaking space than ordinary space?

Re: Blank space format problem

robert_mika — Thu, 09 Apr 2015 09:38:20 GMT

This should shed some light:

stackoverflow.com/questions/1357078/whats-the-difference-between-nbsp-and

Re: Blank space format problem

henrikalmen — Thu, 09 Apr 2015 09:53:41 GMT

Ah yes of course, it will actually work as a non breaking space when used. Should have guessed that myself, but thank you! 🙂