topic Re: scientific notation in QlikView

scientific notation

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

Hope that all are well.

Things have been going well.

I have run into one problem.

I am performing a computation as part of my load that is resulting in scientific notation i.e. 2.81109796934533e-008.

I am trying to convert this to a truncated numeric expression i.e. 2.811.

I have tried a number of things using the Num function:

- (Num(PT/AVL)/(DYSX * 365)),'(dec)')

- (Num(PT/AVL)/(DYSX * 365)),'##.##')

and no change.

Please help.

Thanks,

Mitch

sunny_talwar — Mon, 09 May 2016 21:04:42 GMT

May be like this:

Num#(Left((PT/AVL)/(DYSX * 365), 5)) as FieldName

ramoncova06 — Mon, 09 May 2016 21:31:08 GMT

Num(PT/AVL)/(DYSX * 365),'#,##0.00')

Mon, 09 May 2016 21:42:32 GMT

It worked and thank you for the quick response

swuehl — Mon, 09 May 2016 21:49:18 GMT

Do you have always the same exponent?

Or how do you use this truncated number then?

If you have always the same exponent, you can also multiply to get your number in a certain range:

Num( (PT/AVL)/(DYSX * 365)*1E8,'#.000')