Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Convert Exponential values in Numbers???

Please find the attached document,

In my application, you'll notice that in Column TO_BALANCE containing data like 1e+017,

but i need to present the data which is not in the exponential form

i:e:- 100000000000000000

Regards.

Zain

1 Solution

Accepted Solutions
Highlighted
sivarajs
Valued Contributor II

Re: Convert Exponential values in Numbers???

Try using this

num(num#(TO_BALANCE),'##################') as TO_BALANCE

View solution in original post

3 Replies
Luminary
Luminary

Re: Convert Exponential values in Numbers???

Hi,

Use

LOAD num(TO_BALANCE,'##################'),

     ACTUAL_RATE

FROM ...

Not applicable

Re: Convert Exponential values in Numbers???

i applied it but, still have the same problem

Highlighted
sivarajs
Valued Contributor II

Re: Convert Exponential values in Numbers???

Try using this

num(num#(TO_BALANCE),'##################') as TO_BALANCE

View solution in original post