topic Re: Need after data '|' in QlikView

Need after data '|'

priyarane — Wed, 04 Nov 2015 09:14:01 GMT

Hi Community,

Need data after '|'...

My data looks like below.

Dim:

ABCD|1234

DEFG|5678

I need to have data to be display like:

Dim:

ABCD

DEFG

Kushal_Chawda — Wed, 04 Nov 2015 09:16:19 GMT

try

subfield(Dim,'|',1) as Field

sasikanth — Wed, 04 Nov 2015 09:22:13 GMT

hi,

Try some thing like

field_Name&'|' as New_field

vipin_mishra479 — Wed, 04 Nov 2015 09:25:47 GMT

Try this in script

Subfield(Dim,'|',1) as Dim

arasantorule — Wed, 04 Nov 2015 10:12:27 GMT

Hi,

Please use Subfield('ABCD|1234','|',-1) .

Also please ensure only one '|' is available in the string to ensure the accuracy.

Thanks