topic Re: Num#() in Oracle in QlikView

Num#() in Oracle

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

Hi Community,

Due to some reason I can't use Num#() in load script but need to implement same in Select statement (oracle DB) in Load script of QVW. But didn't find exact match of Num#() in oracle, so can someone pls suggest.

_Priya

Re: Num#() in Oracle

sergio0592 — Fri, 13 Sep 2019 14:03:07 GMT

Hi,

Try with to_number Oracle function.

Re: Num#() in Oracle

priyarane — Fri, 13 Sep 2019 14:08:15 GMT

it didn't work,

I have values like

Dim1

0.2

0.199992

12.5

2.93847

So I want to get all values after decimal.

Re: Num#() in Oracle

Vegar — Sun, 15 Sep 2019 06:51:24 GMT

Try

Sql select

TO_NUMBER(Dim1, '99.9999999')

From db

Re: Num#() in Oracle

Brett_Bleess — Thu, 26 Sep 2019 12:34:38 GMT

Priya, did Vegar's post get things working for you? If so, please be sure to use the Accept as Solution button to mark his post as correct and give him credit. If you are still having issues, leave an update on where things stand. The only other thing I could recommend would be checking the Oracle Community, as they would be the experts on this one as well...

Regarding the Load statement side of things, sometimes you have to use a combination of the formatting functions to get what you really want, just FYI, and in this case, what would have probably helped is if you could have attached a sample QVW with the issue and maybe a QVD with some of the source data, so we could have tried to figure out why things were not working for you in the Load statement.

The following Design Blog post may be of some further help possibly:

https://community.qlik.com/t5/Qlik-Design-Blog/Automatic-Number-Interpretation/ba-p/1475352

Regards,
Brett

Re: Num#() in Oracle

priyarane — Thu, 26 Sep 2019 12:54:43 GMT

Working with below statement

rtrim(to_char(x, 'FM999999999999990.99'), '.')