topic Business day hours in QlikView

Business day hours

ch_riadh — Mon, 05 Sep 2016 13:24:22 GMT

Hello guys,

my business day is from 04am of today to 04am of tomorrow.

For Exemple transaction done at 2am of 05/09/2016 it should be stored on 04/09/2016.

So i want to create a fild 'BusinessDate'

like :

if(time(Createdate,'hh:mm')> '00:00' and time(Createddate,'hh:mm' )<'04:00' , Transdate-1 , Transdate) as BusinessDate,

Createdate and Transdate exist in my Table.

Thanks

Re: Business day hours

marcus_sommer — Mon, 05 Sep 2016 13:27:46 GMT

Maybe something like this:

date(floor(Createddate - 4/24)) as BusinessDate

- Marcus

Re: Business day hours

saimahasan — Mon, 05 Sep 2016 13:29:39 GMT

So whats the issue you are facing???

Is it that the expression not working correct??

Re: Business day hours

ch_riadh — Mon, 05 Sep 2016 13:36:06 GMT

yes i want to create this BDATE
and this Businessday filed start from 04:00 to 04:00 of next day.

Re: Business day hours

saimahasan — Mon, 05 Sep 2016 13:43:51 GMT

I tried the same expression and it worked well.

If i am not wrong, do you need the output something similar to this??

Re: Business day hours

jpenuliar — Mon, 05 Sep 2016 14:00:15 GMT

try maybe :

daystart ‒ QlikView

Re: Business day hours

ch_riadh — Mon, 05 Sep 2016 14:02:47 GMT

yes this is what i need.

But how you wrote it and where.

Re: Business day hours

saimahasan — Mon, 05 Sep 2016 14:30:23 GMT

To whom are you asking??

Re: Business day hours

ch_riadh — Mon, 05 Sep 2016 15:11:47 GMT

‌to you

you wrot it in the editor right.

can you write it again for me please

or put a screenshot of the editor please

thanks

Re: Business day hours

saimahasan — Mon, 05 Sep 2016 15:18:41 GMT

You can write this script:

This is the dummy data i have created.

LOAD * INLINE [

Time

02:02

01:04

05:32

10:30

01:40

03:59

07:56

21:54

18:20

16:30

17:45

];

LOAD Time,

if(time(Time,'hh:mm')> '00:00' and time(Time,'hh:mm' )<'04:00' , Date(Today()-1) , Date(Today())) as Businessdate

Resident A;

DROP Table A;