topic Re: How to prevent exponential numbers auto-convert? in QlikView https://community.qlik.com/t5/QlikView/How-to-prevent-exponential-numbers-auto-convert/m-p/950561#M974779 <HTML><HEAD></HEAD><BODY><P>Thank you for the response, but it doesn't work, I've tried this before post it here... The only way it could be possible is if I contatenate it with another character, then removing it at the load on the others dashboards... It doesn't are nor feel right and I can't change all the others dashboards that use this extraction just for these particular cases...</P></BODY></HTML> Tue, 01 Sep 2015 17:15:13 GMT 2015-09-01T17:15:13Z How to prevent exponential numbers auto-convert? https://community.qlik.com/t5/QlikView/How-to-prevent-exponential-numbers-auto-convert/m-p/950559#M974777 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm using a application that have a field that contains data set as VARCHAR2, in oracle pl/sql, and when I extract that field some data come like a result in exponential. For example: I have a field that contains a company's ID like 001E2, and I want it to stay that way, but whenever I extract that, or try to transform in text, it always shows 00100... </P><P></P><P>Thanks for the help.</P></BODY></HTML> Tue, 01 Sep 2015 15:18:55 GMT https://community.qlik.com/t5/QlikView/How-to-prevent-exponential-numbers-auto-convert/m-p/950559#M974777 2015-09-01T15:18:55Z Re: How to prevent exponential numbers auto-convert? https://community.qlik.com/t5/QlikView/How-to-prevent-exponential-numbers-auto-convert/m-p/950560#M974778 <HTML><HEAD></HEAD><BODY><P>hi you can use text(ID) in the script</P></BODY></HTML> Tue, 01 Sep 2015 16:06:35 GMT https://community.qlik.com/t5/QlikView/How-to-prevent-exponential-numbers-auto-convert/m-p/950560#M974778 lironbaram 2015-09-01T16:06:35Z Re: How to prevent exponential numbers auto-convert? https://community.qlik.com/t5/QlikView/How-to-prevent-exponential-numbers-auto-convert/m-p/950561#M974779 <HTML><HEAD></HEAD><BODY><P>Thank you for the response, but it doesn't work, I've tried this before post it here... The only way it could be possible is if I contatenate it with another character, then removing it at the load on the others dashboards... It doesn't are nor feel right and I can't change all the others dashboards that use this extraction just for these particular cases...</P></BODY></HTML> Tue, 01 Sep 2015 17:15:13 GMT https://community.qlik.com/t5/QlikView/How-to-prevent-exponential-numbers-auto-convert/m-p/950561#M974779 2015-09-01T17:15:13Z Re: How to prevent exponential numbers auto-convert? https://community.qlik.com/t5/QlikView/How-to-prevent-exponential-numbers-auto-convert/m-p/950562#M974780 <HTML><HEAD></HEAD><BODY><P>I have found how to prevent the conversion of a exponecial number, it was in the release notes from the 11th version. There are a new variable named <EM>ExponentNumberNotation</EM> that can be set to <EM>0</EM> to ignore the conversion of the exponencials...</P><P></P><P>This topic can be closed now.</P><P></P><P>Thank you.</P></BODY></HTML> Tue, 01 Sep 2015 17:58:45 GMT https://community.qlik.com/t5/QlikView/How-to-prevent-exponential-numbers-auto-convert/m-p/950562#M974780 2015-09-01T17:58:45Z