topic Re: Problem formatting numbers from a QVD in QlikView

Problem formatting numbers from a QVD

marcel_olmo — Sat, 16 Nov 2024 03:51:13 GMT

Hi guys,

I have a QVD with 3 values, the column1 and the column3 are detected as numbers, and you can do a sum() with no problems, but that’s not the case in the column2 and I don’t now why :

I’ve tried num(), num#() in all the combinations I know with no results.

Anybody knows what’s needed to do to get a number in column2 as well?

I’ve attached my qvd and a sample in qvw.

Regards, Marcel.

Re: Problem formatting numbers from a QVD

Nicole-Smith — Mon, 15 Apr 2019 17:16:51 GMT

There are some extra characters in the field that isn't coming through properly (there is some blank space before the numbers--it's why they're not showing right next to the column border). The following seems to fix the issue when I tried running it:

LOAD Period, 
     Value1, 
     KeepChar([Value1 +/-], '-.,01234567890') AS [Value1 +/-], 
     [Value2 +/-]

Re: Problem formatting numbers from a QVD

marcel_olmo — Wed, 24 Apr 2019 08:45:59 GMT

Thanks Nicole! That was it.

Regards, Marcel.