Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends, I m facing a problem .Please suggest me the solution for the problem.
hey guys,how to convert an exponential number to decimal in
qlikview?
i tried mantissa*pow(10,exp) formula but mantissa that i
separate from the original field
,it is showing that it is neither a text nor a number.
Thanks in advance
Kamal Naithani
But what can i do?, i used the code from your post..
what version are you on ?
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".....