topic Re: Exponential Value Conversion at front end in QlikView

Exponential Value Conversion at front end

abhaysingh — Mon, 08 Feb 2016 09:37:16 GMT

Hey Guys,

I have one calculation in which i m multiplying two value,

A * B = 1.7741025325602e+016

i want to convert it into number..How can i handle them at front end?

Re: Exponential Value Conversion at front end

arulsettu — Mon, 08 Feb 2016 09:40:13 GMT

may be this in text object

=num('1.7741025325602e+016','(dec)')

Re: Exponential Value Conversion at front end

Chanty4u — Mon, 08 Feb 2016 09:42:22 GMT

=Num(Replace('4.42E+11', ',', '.'), '(dec)')

nd chk dis

Exponents not showing as numbers in Qlikview

Re: Convert scientific/exponential format to number value

Re: Exponential Value Conversion at front end

MK_QSL — Mon, 08 Feb 2016 09:44:13 GMT

Conversion of Exponential Notation to Decimal numbers

Re: Exponential Value Conversion at front end

abhaysingh — Mon, 08 Feb 2016 12:26:57 GMT

Not Working in My scenario at front end calculation

Re: Exponential Value Conversion at front end

jonathandienst — Mon, 08 Feb 2016 12:32:41 GMT

Qlikview can represent numbers up to 14 digits without exponential notation, Your number is 16 digits, so you cannot get it displayed without an exponent.

By the way it is a number. e+016 means multiply the mantissa (1.7741025325602) by 10^16