Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to convert an exponential no to decimal

But what can i do?, i used the code from your post..

Not applicable

Re: How to convert an exponential no to decimal

what version are you on ?

Highlighted
Not applicable

Re: How to convert an exponential no to decimal

11.00.11154.0

I got it working:

Num(Left(@5, Index(@5, 'E') -1) * Pow(10, TextBetween(@5, 'E', ''))) as meas,

     Num(Left(@6, Index(@6, 'E') -1) * Pow(10, TextBetween(@6, 'E', ''))) as mean,

     Num(Left(@7, Index(@7, 'E') -1) * Pow(10, TextBetween(@7, 'E', ''))) as lower,

     Num(Left(@8, Index(@8, 'E') -1) * Pow(10, TextBetween(@8, 'E', ''))) as upper,

For now i'm happy, although it would have been easier to just say "this is a number".....

Community Browser