Discussion board where members can get started with Qlik Sense.
Can any one please help me to replicate the below logic into qlik
=If(OR(ISBLANK(Startdate ), ISBLANK(Enddate)),"",
Thanks in advance.
Go to 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.
may be like this in qlik
if(isnull(Startdate) or isnull(Enddate),''
,if(Type='New' and Status='Completed',
you can try:
IF(Startdate>0 OR Enddate >0, IF(Type = 'New' AND Status = 'Completed',NETWORKDAYS(Startdate,Enddate)))