topic Re: Compare timestamps in QlikView

Compare timestamps

Anonymous — Fri, 27 Feb 2015 08:07:42 GMT

Hi all,

I would like to create a report with all orders which are created after a specific date and time.

All orders have a created timestamp. I would like to see all orders which are created since 15:00 o'clock the day before today.

I tried different formats, but I can't get it done. Could someone please explain which format I need to use for the following fields to compare them?

Many thanks!

Kind regards,

Henco

simospa — Fri, 27 Feb 2015 08:10:57 GMT

Hi,

did you try to create in load script a field structured as YYYYMMDDHHMMSS? So it will be easy to comparate two integers...

Anonymous — Fri, 27 Feb 2015 08:16:27 GMT

Hi Simone,

Thanks for your reply.

I tried to load the createdate from the oracle database like this: to_char(aoadorder.createdate,'DD-MM-YYYY HH24:MI')

In QV I created a variable like this: timestamp#(today()&' 15:00')

But when I compare these two, it has no effect. So I assume I do something wrong with the formats.

Kind regards,

Henco

Fri, 27 Feb 2015 08:28:23 GMT

Hi Henco,

I think you can use Timestamp#() function.After this it is just as simple as integer comparison.

Regards.

Anonymous — Fri, 27 Feb 2015 08:36:22 GMT

Hi,

In script create variable:

Let vTime = Time(Frac(Today()-1),'03:00');

In UI:

=sum({$<Date={'>=$(=today()-1)'}, Time = {'>=$(=vTime)'}>} Amount)

Regards

Neetha

Anonymous — Fri, 27 Feb 2015 08:57:07 GMT

Thanks, you pointed me in the right direction. Solved the problem by first checking the date and after that checking the time.

Regards,

Henco