Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use this :
=only(if(ER1='BAP_OCI' and ER2='BAP_OCI','ICC','SAP'))
Thank u for the reply.
However, the logic should include one more condition stating only Automatic postings , i need the logic below.