Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Num#() in Oracle

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

1 Solution

Accepted Solutions
priyarane
Specialist
Specialist
Author

Working with below statement

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

View solution in original post

5 Replies
sergio0592
Specialist III
Specialist III

Hi,

Try with to_number  Oracle function.

priyarane
Specialist
Specialist
Author

it didn't work,

I have values like 

Dim1

0

0.2

0.199992

12.5

2.93847

 

So I want to get all values after decimal.

Vegar
MVP
MVP

Try

Sql select

TO_NUMBER(Dim1, '99.9999999')

From db

 

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
priyarane
Specialist
Specialist
Author

Working with below statement

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

View solution in original post