Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andrea0901
Creator
Creator

logic problem - qlikview

Hi All,

 

I have a requirement like below:

ER1ER2AUTOLIVE
BAP_OCIBAP_OCIAutomaticICC
ACACAutomaticSAP
AkumarAkumarAutomaticICC
AshekAshekAutomaticSAP
aniyasaniyasAutomaticICC
BAP_OCIBAP_OCINot AutomaticSAP
ACACNot AutomaticICC
AkumarAkumarNot AutomaticSAP
AshekAshekNot AutomaticICC
aniyasaniyasNot AutomaticSAP

 

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.

1 Solution

Accepted Solutions
Shubham_Deshmukh
Specialist
Specialist

=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.

View solution in original post

3 Replies
Shubham_Deshmukh
Specialist
Specialist

Use this : 

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

andrea0901
Creator
Creator
Author

Thank u for the reply.

 

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

Shubham_Deshmukh
Specialist
Specialist

=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.