Repeat calculated value if ID is the same.

[robin_heijt]

Hi,

I have the following field:

If the ID is the same I want the 4A Implementation to show implemented for all lines.

I use this to calculate implementation.

 IF("Movement Type"='Promotion Band Up','Implemented' ,
 IF("Movement Type"='Promotion Within Band','Not Implemented' ,
 IF("Movement Type"='Lateral Move','Not Implemented' ,
 IF(isnull("Movement Type"), 'Not Implemented' ,
 IF("Movement Type"='Termination Voluntary','Not Implemented',
 IF("Movement Type"='Termination Involuntary', 'Not Implemented')))))) as "4A Implementation"

Thanks.

[manisha_qlik]

Use IF and Match function to resolve this. For ex.

IF(MATCH(STATE, 'NC','NJ','CT')>0,'USA', 'UK') as Country.

[robin_heijt]

Unfortunately that returns the same result.

[robin_heijt]

Please note that the fields are coming from 2 concatenated tables