topic Facing problem in screpting in QlikView

Facing problem in screpting

lucky1618 — Tue, 03 Sep 2019 13:54:46 GMT

hi all

i need a answer for this,

i am loading three fields from qvd , one of the field having both numeric and char but i want to display only numeric values .

LOAD [SHIP REGISTERED IN],
[VESSEL NAME],
[Container Number]

this is my fields and [Container Number] i want to display this field .

Re: Facing problem in screpting

Miguel_Angel_Baeyens — Tue, 03 Sep 2019 14:00:04 GMT

Do you want to clean up the field from non-numeric values?

Use KeepChar([Container Number], '0123456789')

Do you want instead to only load those records for which the value of [Container Number] is numeric only? Do

LOAD ...

FROM...

WHERE IsNum([Container Number])

Do you want to load all data but only display in a listbox or a chart those rows for which [Container Number] is numeric?

Create a new field in the script for that

LOAD ...

If(IsNum([Container Number]), [Container Number], Null()) AS [Container Numeric Only]

...

Re: Facing problem in screpting

lucky1618 — Tue, 03 Sep 2019 14:50:10 GMT

Hi Miguel,

thanks for your support ,but still i did not get the answer, please check my code once . [Container Number] values are like this TGHU226073 ,LTIU606255

i want to display only numeric values.

//load * where [Container Number]= KeepChar([Container Number],'0123456789');
LOAD [SHIP REGISTERED IN],
[VESSEL NAME],
[Container Number]
//iF(IsNum([Container Number]),[Container Number],null()) as number
FROM
[C:\Users\srinivasu\Desktop\Qlikview files\Folder Structure\FDS\Extract_QVD\Shiprereg.qvd]
(qvd)
Where IsNum([Container Number]);

Re: Facing problem in screpting

Miguel_Angel_Baeyens — Wed, 04 Sep 2019 15:31:38 GMT

LOAD *,

KeepChar([Container Number], '0123456789') AS [Container Number Only]

FROM ...

Note that this will create a new field with only the numeric values from [Container Number], so in your examples, this field will store "226073" and "606255".

Re: Facing problem in screpting

lucky1618 — Wed, 04 Sep 2019 17:04:22 GMT

Thank u Miguel i got answer.