topic Re: grouping date only not the time element in QlikView

grouping date only not the time element

qlikmpate0 — Fri, 24 Apr 2015 14:02:05 GMT

How can one group dates in scripting

My example is I have several dates including the time, but I only want to show data for each day and ignore the time?

Hope this makes sense.

regards

Re: grouping date only not the time element

Gysbert_Wassenaar — Fri, 24 Apr 2015 14:30:45 GMT

You can use the floor function to cut of the time part from a date:

date(floor(MyDateTime),'DD-MM-YYYY') as MyDate

If your datetime (timestamp) field doesn't contain numeric values but text values you can use the date# function to turn the text values into dates. You'll still should use the floor function. Date(floor(date#(MyField, 'YYYYMMDD hhmmss')),'DD-MM-YYYY')

Note, all the date and timestamp formats above are just examples. Use the formats you actually need.

Re: grouping date only not the time element

awhitfield — Fri, 24 Apr 2015 14:34:53 GMT

Hi Mina,

you can strip out the hh:mm:ss etc, and just keep the date

an example of this is:

FixDate:
Load * inline
[
TimeStamp
24/02/1958 11:12:32
];

FinalDate:

Load
TimeStamp,
Date(Floor(TimeStamp)) as NewDate
Resident FixDate;

Gives a new date of 24/02/1958 from 24/02/1958 11:12:32

Regards

Andy

Re: grouping date only not the time element

qlikmpate0 — Fri, 24 Apr 2015 15:00:11 GMT

Thank you

Re: grouping date only not the time element

qlikmpate0 — Fri, 24 Apr 2015 15:01:02 GMT

Thank you.

Re: grouping date only not the time element

MarcoWedel — Sat, 25 Apr 2015 00:10:13 GMT

Hi,

you could use

DayName(YourTimestampField)

to purge the time part from the timestamp and format as a date

hope this helps

regards

Marco