topic If condition not working in QlikView

If condition not working

ramyasaiqv — Thu, 28 Sep 2017 16:09:39 GMT

Hello All,

I’m trying to derive “Open_Date” from “Date “ in the script using the following condition but getting nulls. Please help me. Attached sample qvw, excel and expected result set for reference. Thank you,

if(Type= 'BCT' and Status='Accepted' and Type='ECT' and Status='Open' or '-', Date) as Open_Date

Expected Result: 3/12/2016 (BUS)

8/20/2015 (PTZ)

Ramya

Re: If condition not working

sunny_talwar — Thu, 28 Sep 2017 16:19:19 GMT

How can type be BCT and ECT at the same time... same problem with Status... may be you need or condition?

Re: If condition not working

krishnacbe — Thu, 28 Sep 2017 16:26:18 GMT

Check the attached file. hope it helps.

Changed the formula as below.

if((Type= 'BCT' or Type='ECT') and (Status='Accepted' or Status='Open'), Date) as Open_Date

Re: If condition not working

ramyasaiqv — Thu, 28 Sep 2017 16:35:40 GMT

Thank you Sunny.

Ramya

Re: If condition not working

ramyasaiqv — Thu, 28 Sep 2017 16:36:26 GMT

Thank you for the response Krishnapriya.

Ramya