topic Re: ignore value in subfield in QlikView

ignore value in subfield

Tue, 07 Aug 2012 13:51:15 GMT

Hi all

İ tried to combine 4 columns into one column with this script

subfield(DS_DELAY_SUB_CODE_1 & ';' & DS_DELAY_SUB_CODE_2 & ';' & DS_DELAY_SUB_CODE_3 & ';' & DS_DELAY_SUB_CODE_4, ';') as DS_DELAY_SUB_CODE

But i want to ignore '?' character in this subfields

how can i do this

thnaks

Re: ignore value in subfield

Tue, 07 Aug 2012 13:58:53 GMT

purgechar(

subfield(DS_DELAY_SUB_CODE_1 & ';' & DS_DELAY_SUB_CODE_2 & ';' & DS_DELAY_SUB_CODE_3 & ';' & DS_DELAY_SUB_CODE_4, ';')

,'?')

Re: ignore value in subfield

Tue, 07 Aug 2012 14:01:32 GMT

will i take all sub_codes without '?'

Re: ignore value in subfield

Tue, 07 Aug 2012 14:02:36 GMT

i think so

try it

Re: ignore value in subfield

Tue, 07 Aug 2012 14:02:49 GMT

The purgechar will remove all ? from the string subfield(DS_DELAY_SUB_CODE_1 & ';' & DS_DELAY_SUB_CODE_2 & ';' & DS_DELAY_SUB_CODE_3 & ';' & DS_DELAY_SUB_CODE_4, ';')