Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qliksus
Specialist II
Specialist II

Text to Number Formatting Issue

Hi,

I have loaded data from excel joined with inline data, but excel data considered as Number where as Inline data considered inside Qlikview as Text which doesn't create proper link.

Pls find the attached JPEG file where you can see Excel data is in number and Inline is in Text where as both case numbers are same in both cases.

Can anyone help me to solve this?

11 Replies
qliksus
Specialist II
Specialist II
Author

Thanks Marco. Just want tom know what is the output of  using '(dec)'

Clever_Anjos
Employee
Employee

Be careful about this

"Note that while using Evaluate() returns a number, it is only stored with 14 digit precision.  While you may be able to see more than 14 digits, this is just the formatting.  The internal mantissa is only 14 digits."