Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Numbers not aligning right

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

InternetPlans.PNG

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

5 Replies
sunny_talwar

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

Anonymous
Not applicable
Author

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

sunny_talwar

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

It did work!!! Thank you!