topic Transact Time flag in QlikView

Transact Time flag

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I would appreciate some help with the best way to flag timestamps between a range.

For example I have a field TransactTime and I would like to report all TransactTime's between 23:00 - 06:00.

Any help would be great.

Regards,
Daniel

sunny_talwar — Mon, 16 Mar 2020 14:12:01 GMT

Does this field only include time or is it made up of date and time both?

danielnevitt — Mon, 16 Mar 2020 14:14:39 GMT

Hi Sunny,

The field contains date and time.

Thanks,
Daniel

sunny_talwar — Mon, 16 Mar 2020 14:18:48 GMT

May be create a flag like this

If(Frac(TransactTime) >= MakeTime(23) or Frac(TransactTime) <= MakeTime(6), 1, 0) as TimeFlag