topic Re: sub string in QlikView

sub string

Tue, 03 Jul 2012 08:49:00 GMT

hi all

at the attached excel

i have four columns (code1, code2, code3, code4)

for every rows if these four columns dont contain any of code_checks

i want to count it

how can i do this

thanks

Tue, 03 Jul 2012 09:48:32 GMT

i tried to use a method like this

SubStringCount( DS_DELAY_SUB_CODE_1&'|'&DS_DELAY_SUB_CODE_2&'|'&DS_DELAY_SUB_CODE_3&'|'&DS_DELAY_SUB_CODE_4, Kod )

but i couldnt solve.

vincent_ardiet — Tue, 03 Jul 2012 10:07:07 GMT

Hi,

You can try with something like :

=sum((if(wildmatch (concat (code_check,'|'),'*'&code1&'*','*'&code2&'*','*'&code3&'*','*'&code4&'*' )=0,1,0))

Regards,

Vincent

Tue, 03 Jul 2012 10:58:00 GMT

it turns no data display

Tue, 03 Jul 2012 11:26:40 GMT

i will change my question thanks Vincent

Tue, 03 Jul 2012 11:39:55 GMT

i explained my issue in this topic

Vincent thanks for your answers