topic Re: if logic help in QlikView

if logic help

mahitham — Wed, 25 Nov 2020 16:16:04 GMT

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.

tresB — Wed, 30 May 2018 09:17:59 GMT

Qlik too has a networkdays().

mahitham — Wed, 30 May 2018 09:24:39 GMT

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 — Wed, 30 May 2018 09:25:45 GMT

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

tresB — Wed, 30 May 2018 09:29:08 GMT

Try like:

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