topic Re: Need help on a formula when comparing for two things that must match in Talend Studio

Need help on a formula when comparing for two things that must match

SDeLa131 — Fri, 02 Jan 2026 14:45:42 GMT

count({$<[VCODETAIL_Credit Reason] = {'009','010','011','012','013','014','015','016','017','018','019','020','022','023','036','037'}, [VCODETAIL_Credit Person] = {'AL','AF','AS', 'CD','DF','EB','EW','HS','KMK','MO','MS','MG','MJ','MF','RB','RC','SR','SW'}>} [OrderHeader Count])

above is the formula, but its only counting for the credit reason codes but its not pulling from the right credit person that is found in the file VCODETAIL. Why?

Re: Need help on a formula when comparing for two things that must match

mpc — Mon, 07 Apr 2025 08:05:23 GMT

Hi,

Maybe this one:

count({$<[VCODETAIL_Credit Reason] = {'009','010','011','012','013','014','015','016','017','018','019','020','022','023','036','037'}>+ <[VCODETAIL_Credit Person] = {'AL','AF','AS', 'CD','DF','EB','EW','HS','KMK','MO','MS','MG','MJ','MF','RB','RC','SR','SW'}>} [OrderHeader Count])

(Set operators | Qlik Sense on Windows Help) Since + is the union operator

Best

Re: Need help on a formula when comparing for two things that must match

marcus_sommer — Mon, 07 Apr 2025 09:12:31 GMT

If both fields and their values needs to be evaluated in common a set analysis isn't suitable else an if-loop will ne necessary, maybe like:

if(match([VCODETAIL_Credit Reason],
'009','010','011','012','013','014','015','016','017','018','019','020','022','023','036','037') and
match([VCODETAIL_Credit Person],
'AL','AF','AS', 'CD','DF','EB','EW','HS','KMK','MO','MS','MG','MJ','MF','RB','RC','SR','SW'), count([OrderHeader Count]))