sub string

[#1]

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

[#2]

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]

Hi,

You can try with something like :

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

Regards,

Vincent

[#4]

it turns no data display

[#5]

i will change my question thanks Vincent

[#6]

http://community.qlik.com/thread/56602

i explained my issue in this topic

Vincent thanks for your answers