topic Re: variable time in QlikView

variable time

raadwiptec — Fri, 09 Oct 2015 13:00:31 GMT

Hi all ,

is it possible to store an specific time value in a variable

for ex if have 2 columsn

employee ¦ intime

1 ¦ 2015-10-23 09:09:10

2 ¦ 2015-10-23 09:00:10

3 ¦ 2015-10-23 09:01:11

4 ¦ 2015-10-23 09:07:18

5 ¦ 2015-10-23 08:09:23

for example:let vTimestandard =8:00

then compare intime.. here I need to check all the intime greater than vtimestandard

Re: variable time

sunny_talwar — Fri, 09 Oct 2015 13:05:19 GMT

Yes you can store a time value in a variable, but to make it comparable you will need them to be at the same level. Like for right now your column intime contains date as well as time, but you variable only contains time. The comparison won't work this way. You can compare time to time or timestamp to timestamp.

Does that make sense?

Re: variable time

raadwiptec — Fri, 09 Oct 2015 13:11:26 GMT

hi yes I have made another column .which I forgot to mention

employee ¦ intime ¦ scantime

1 ¦ 2015-10-23 09:09:10 ¦ 09:09:10

2 ¦ 2015-10-23 09:00:10 ¦ 09:00:10

3 ¦ 2015-10-23 09:01:11 ¦ 09:01:11

4 ¦ 2015-10-23 09:07:18 ¦ 09:07:18

5 ¦ 2015-10-23 08:09:23 ¦ 08:09:23

still how do I compare can u share the script? I tried hardcodeing value to variable but it is not working

Re: variable time

petter — Fri, 09 Oct 2015 13:11:28 GMT

Yes you can for example in a load script:

LET vTimestandard = Num(Time('08:00:00'));

LOAD

employee,

intime,

Frac(intime) > $(vTimestandard) AS IsLate

INLINE [

employee ¦ intime

1 ¦ 2015-10-23 09:09:10

2 ¦ 2015-10-23 09:00:10

3 ¦ 2015-10-23 09:01:11

4 ¦ 2015-10-23 09:07:18

5 ¦ 2015-10-23 08:09:23

] ( delimiter is '¦');

Re: variable time

sunny_talwar — Fri, 09 Oct 2015 13:16:19 GMT

If you want to do this in the script, than you can do it Petter's way. For front end solution you can look at the attached image and qvw file.

The expression I am using here is: =Only({<Time = {"$(='>=' & vTimeStandard)"}>}inTime)

and variable vTimeStandard = =Time(Time#('8:00', 'h:mm'))

HTH

Best,

Sunny

Re: variable time

raadwiptec — Fri, 09 Oct 2015 13:52:26 GMT

hi sunny,

=Time(Time#('8:00', 'h:mm')) this comparison is not working 24 hrs time

for ex: =Time(Time#('18:00', 'h:mm')) if I try .. I does not work..how can make it for 24 hrs time

Re: variable time

sunny_talwar — Fri, 09 Oct 2015 13:54:51 GMT

See if this helps:

=Time(Time#('18:00', 'hh:mm'))

Re: variable time

Kushal_Chawda — Fri, 09 Oct 2015 14:10:38 GMT

LET vTimestandard= frac(Time#('08:00:00','hh:mm:ss'));

Data:

LOAD *,

if(frac(Time) >'$(vTimestandard)',1,0) as TimeFlag;

load *,Time(intime,'hh:mm:ss') as Time,

date(intime) as Date INLINE [

employee, intime

1, 2015-10-23 09:09:10

2, 2015-10-23 09:00:10

3 ,2015-10-23 09:01:11

4, 2015-10-23 09:07:18

5, 2015-10-23 08:09:23

6, 2015-10-23 07:09:23

] ;

Create straight Table

Dimensions:

employee

Date

Time

Expression

=Only({<TimeFlag={'1'}>}intime)

Re: variable time

raadwiptec — Mon, 12 Oct 2015 07:20:30 GMT

hi guys ,

can you tell me ..hoiw could I put between for vTimestandard

LET vTimestandard= frac(Time#('08:00:00','hh:mm:ss'));

for example: I need to set timings between 8PM(20:00), in the night until morning 6 AM - I need only that specifc data