topic Re: Time Condition in QlikView

Time Condition

gautik92 — Thu, 03 Sep 2015 12:04:01 GMT

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

Re: Time Condition

stigchel — Thu, 03 Sep 2015 12:07:41 GMT

try with

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

Re: Time Condition

gautik92 — Thu, 03 Sep 2015 12:08:43 GMT

dint work

Re: Time Condition

qlikmsg4u — Thu, 03 Sep 2015 12:09:15 GMT

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

Re: Time Condition

sunilkumarqv — Thu, 03 Sep 2015 12:13:16 GMT

Try this

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

Re: Time Condition

ganeshreddy — Thu, 03 Sep 2015 12:13:49 GMT

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.

Re: Time Condition

sasiparupudi1 — Thu, 03 Sep 2015 12:13:58 GMT

Try

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

Re: Time Condition

gautik92 — Thu, 03 Sep 2015 12:16:55 GMT

dint work

Re: Time Condition

qlikviewwizard — Thu, 03 Sep 2015 13:26:35 GMT

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];