topic CONVERTING TIMESTAMP TO SHOW WORKSHIFT in QlikView

CONVERTING TIMESTAMP TO SHOW WORKSHIFT

Wed, 27 Jun 2012 12:40:33 GMT

Good day

I have a field called EDITDATE that is in a timestamp format. I used the following code to give me a field that shows day or nightshift within my table but it does not work. I have changed my format to show hh:mm only but still it recognises the field as the wrong format.

When I view the table it shows 'NIGHT SHIFT' which it should return when the return expression is false.

PLEASE HELP??????

Re: CONVERTING TIMESTAMP TO SHOW WORKSHIFT

swuehl — Wed, 27 Jun 2012 13:04:32 GMT

Have you tried something like

if( frac(EDITDATE)>= maketime(6) and frac(EDITDATE) <= maketime(18), 'DAY SHIFT', 'NIGHT SHIFT') as SHIFT

Re: CONVERTING TIMESTAMP TO SHOW WORKSHIFT

Wed, 27 Jun 2012 13:18:43 GMT

I have inserted your script and it works fine.....

Thanx a million buddy

Kind regards

Hein.SNJ