topic if condition with AND in QlikView

if condition with AND

surajap123 — Fri, 01 Oct 2021 10:07:47 GMT

Hi Experts,

I want to change the below expression, but it is not working as expected.

From-->
if(field3 = 'Closed', black(),
pick(match(Field2,'NY','LD,','JP'),yellow(),Blue(),green()))

To-->
if(field3 = 'Closed' AND if(Field2 = 'NY',black(),
pick(match(Field2,'LD,','JP'),yellow(),Blue(),green()))

Please help.

AshutoshBhumkar — Fri, 01 Oct 2021 10:16:46 GMT

Hi,

Try this.

if(field3 = 'Closed' AND Field2 = 'NY',black(),
pick(match(Field2,'LD,','JP'),yellow(),Blue(),green())

surajap123 — Fri, 01 Oct 2021 12:00:41 GMT

Thanks for your help