How to Eliminate Format in Qlikview?

[khasimvali85]

Hi Communiry,

I am having data like given below column and this is looking like different format how do remove in qlikview Scripting?

CODE

---------

7.00E+01

6.00E+02

6.00E+04

33286

533287

533296

541082

6.00E+08

6.00E+09

Regards,

Khasim.

[Gysbert_Wassenaar]

Try num(evaluate(CODE))

[Anonymous]

Just the num() function should suffice. Some examples on your data you can check in a Text Box : :

     num(7.00E+01)

     num(533287)

     num(6.00E+09)

or generic with your field:     num(CODE)

[khasimvali85]

Hi Gysbert,

Thanks for reply, I already tried with Num() not working giving same result and also used Num(Evaluate(CODE)),

still same result.

[Anonymous]

It works fine using this script with an inline load :

RawData :

LOAD * INLINE [

    CODE

    7.00E+01

    6.00E+02

    6.00E+04

    33286

    533287

    533296

    541082

    6.00E+08

    6.00E+09

];

load

  num(CODE) as NumCode

resident RawData

;

Could you post an example that demonstrates your problem.

[Gabriel]

Hi,

Try Round(CODE, 0.01)  AS NumCodeFormat

in the script