Time Condition

[gautik92]

I have time

Start time     endtime

08:25.32         -

10:35:12      12:26:35

i want to show if there is no endtime they have not logged out

if(EndTime='Null','Dint Loggedout','Loggedout')

in database there are many null values in endtime

[stigchel]

try with

If(Len(Trim(endtime))=0,'Dint Loggedout','Loggedout')

[gautik92]

dint work

[qlikmsg4u]

Load Starttime,endtime,If(IsNull(endtime) or Len(endtime)<=1,'Dint Loggedout','Logged Out') as Status;

LOAD * Inline [

Starttime,    endtime

08:25.32 ,      

10:35:12 ,     12:26:35

[sunilkumarqv]

Try this

IF(Isnull(endtime) or Len(endtime)<=0,'Didnt Logged out','Logged out')

[ganeshreddy]

Hi Gowtham,

Try this

If (EndTime=null(),'Log out Error','Logged out') as EndTimeDisc,

or you can create a flag for further complex caliculations as

If (EndTime=null(),1,0) as Logout_Flag ,

However you need to check , they are actual null values or is there any spaces involved to try above expressions,

I hope this hepls,

Best regards,

Ganesh.

[sasiparupudi1]

Try

If(KeepChar(endtime,'0123456789')='','Dint Loggedout','Logged Out') as Status;

[gautik92]

dint work

[qlikviewwizard · Accepted solution]

Hi Gowtham,

Use the any script:

Data1:

load *, If(Len(Trim(end_time))=0,'Dint Loggedout','Loggedout') as Status;

LOAD timestamp(Start_time) as Start_time,timestamp(end_time) as end_time  Inline [

Start_time,end_time

08:25.32,

10:35:12,12:26:35

];

Data2:

Load Starttime,endtime,If(IsNull(endtime) or Len(endtime)<=1,'Dint Loggedout','Logged Out') as Status;

LOAD * Inline [

Starttime,endtime

08:25.32 ,  

10:35:12 ,12:26:35];