Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

khasimvali85
Contributor II

How to Eliminate Format in Qlikview?

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.

5 Replies

Re: How to Eliminate Format in Qlikview?

Try num(evaluate(CODE))


talk is cheap, supply exceeds demand

Re: How to Eliminate Format in Qlikview?

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
Contributor II

Re: How to Eliminate Format in Qlikview?

Hi Gysbert,

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

still same result.

Re: How to Eliminate Format in Qlikview?

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
Valued Contributor II

Re: How to Eliminate Format in Qlikview?

Hi,

Try Round(CODE, 0.01)  AS NumCodeFormat

in the script

Community Browser