Need help on IF Logic

[mahitham]

Hi Experts,

Can any one please help me to replicate the below logic into qlik

=If(OR(ISBLANK(Startdate ), ISBLANK(Enddate)),"",

     IF(AND(Type="New",Status="Completed"),NETWRORKDAYS(Startdate,Enddate), "")

  )

Thanks in advance.

[agigliotti · Accepted solution]

take a look at https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/ne...

you can use someting like this:

if( len(trim(Startdate)) = 0 or len(trim(Enddate)) = 0, '',

networkdays( Startdate, Enddate )

) as TimeTaken

Hope it helps.

[arulsettu]

may be like this in qlik

if(isnull(Startdate) or isnull(Enddate),''

,if(Type='New' and Status='Completed',

NETWORKDAYS(Startdate, Enddate))

[avkeep01]

Hi Mahitha,

you can try:

IF(Startdate>0 OR Enddate >0, IF(Type = 'New' AND Status  = 'Completed',NETWORKDAYS(Startdate,Enddate)))