topic Re: Repeat calculated value if ID is the same. in App Development

Repeat calculated value if ID is the same.

robin_heijt — Tue, 11 Dec 2018 17:10:41 GMT

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.

Re: Repeat calculated value if ID is the same.

manisha_qlik — Tue, 11 Dec 2018 17:15:20 GMT

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

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

Re: Repeat calculated value if ID is the same.

robin_heijt — Tue, 11 Dec 2018 17:26:29 GMT

Unfortunately that returns the same result.

Re: Repeat calculated value if ID is the same.

robin_heijt — Tue, 11 Dec 2018 17:32:14 GMT

Please note that the fields are coming from 2 concatenated tables