topic Re: How to Eliminate Format in Qlikview? in QlikView

How to Eliminate Format in Qlikview?

khasimvali85 — Tue, 24 Mar 2015 08:55:37 GMT

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.

Re: How to Eliminate Format in Qlikview?

Gysbert_Wassenaar — Tue, 24 Mar 2015 09:01:22 GMT

Try num(evaluate(CODE))

Re: How to Eliminate Format in Qlikview?

Anonymous — Tue, 24 Mar 2015 09:04:57 GMT

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)

Re: How to Eliminate Format in Qlikview?

khasimvali85 — Tue, 24 Mar 2015 09:16:19 GMT

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?

Anonymous — Tue, 24 Mar 2015 09:36:47 GMT

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.

Re: How to Eliminate Format in Qlikview?

Gabriel — Tue, 24 Mar 2015 13:44:56 GMT

Hi,

Try Round(CODE, 0.01) AS NumCodeFormat

in the script