topic Re: datetime to date in QlikView

datetime to date

Fri, 28 Nov 2014 14:06:05 GMT

Hello,

I'm trying to group my datetimes to 1 record for each day.

I found someting with timestamp and date(datetime, 'YYYY-MM-DD') but it's not working so far.

My query is:

LOAD "vessel_id",

name as Route,

datetime as "Date";

SQL SELECT "vessel_id",

name,

datetime

FROM route

its_anandrjs — Fri, 28 Nov 2014 14:14:11 GMT

Hi,

Try this expression

LOAD "vessel_id",
    name as Route,
    Date(datetime, 'YYYY-MM-DD') as "Date";
SQL SELECT "vessel_id",
    name,
    datetime
FROM route

Regards

Anand

Anonymous — Fri, 28 Nov 2014 14:15:09 GMT

You need to knock the decimal off your timestamp with the floor() function, something like :

date(floor(datetime), 'YYYY-MM-DD')

Fri, 28 Nov 2014 14:26:02 GMT

Hello,

Thank you, this is working so far!

Now i want to group the table by the dates + name. When i do group by datetime, name, "vessel_id" it doesn't work.

Fri, 28 Nov 2014 14:38:17 GMT

Works great, even the group by works here. Thank you!