topic Re: Numbers not aligning right in QlikView

Numbers not aligning right

Anonymous — Mon, 22 Jan 2018 17:37:41 GMT

Hi everyone,

I'm reading a text field from a database and I have to get some numeric data of it. I've done this, but the issue I face is that not all the numbers are align right when stored on a QVD. I've made a field _IsNumber, asking whether the field (MB Available) is considerate numeric or not, and in all cases the answer is NUM (yes).

¿What can possibly be happening? ¿Is QV considering them as numeric, if yes, why is it changing the alignment?

Thanks,

Josefina

Re: Numbers not aligning right

sunny_talwar — Mon, 22 Jan 2018 17:44:55 GMT

Are you looking at this in a table box or straight table?

Re: Numbers not aligning right

Anonymous — Mon, 22 Jan 2018 17:48:04 GMT

I'm opening the QVD with EasyQlik QViewer. The print page is taken from it.

Re: Numbers not aligning right

sunny_talwar — Mon, 22 Jan 2018 17:50:47 GMT

How is MB Available created in the QVD Generator? May be try something like this

[.........] * 1 as [MB Available]

So, basically how every you are creating this number, multiple by 1 and then store it into qvd

Re: Numbers not aligning right

Anonymous — Mon, 22 Jan 2018 17:54:44 GMT

It is being made with trim's and lefts and things like that. I'll try your suggestion. Hope it works

Re: Numbers not aligning right

Anonymous — Mon, 22 Jan 2018 17:58:13 GMT

It did work!!! Thank you!