logic problem - qlikview

[andrea0901]

Hi All,

I have a requirement like below:

ER1	ER2	AUTO	LIVE
BAP_OCI	BAP_OCI	Automatic	ICC
AC	AC	Automatic	SAP
Akumar	Akumar	Automatic	ICC
Ashek	Ashek	Automatic	SAP
aniyas	aniyas	Automatic	ICC
BAP_OCI	BAP_OCI	Not Automatic	SAP
AC	AC	Not Automatic	ICC
Akumar	Akumar	Not Automatic	SAP
Ashek	Ashek	Not Automatic	ICC
aniyas	aniyas	Not Automatic	SAP

For all "Automatic" postings  --->>> 'LIVE' field will be changed based on below logic

a.       if ER1 & ER2 = BAP_OCI then LIVE field should show = ICC

b.       if ER1 & ER2 not equal to BAP_OCI then LIVE field should show = SAP

Please help me how to do it in qlikview.

[Shubham_Deshmukh]

Use this : 

=only(if(ER1='BAP_OCI' and ER2='BAP_OCI','ICC','SAP'))

[andrea0901]

Thank u for the reply.

However, the logic should include one more condition stating only Automatic postings , i need the logic below. 

[Shubham_Deshmukh · Accepted solution]

=only(if(ER1='BAP_OCI' and ER2='BAP_OCI' and AUTO='Automatic' ,'ICC','SAP'))
Mark the solution as an answer if it solves your problem.