if logic help

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

[tresesco]

Qlik too has a networkdays().

[mahitham]

Hi Tresesco,

Thanks for your reply.

could you please help me to replicate this whole logic into Qlik.

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

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

  )

Thanks in advance.

[arulsettu]

may be like this in qlik

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

NETWORKDAYS('21/11/2017' , '27/11/2017' ))

replace date with your date field

[tresesco · Accepted solution]

Try like:

if(Type='New' and Status='Completed', NetWorkDays(Startdate,Enddate))