topic Dates with hours, in QlikView

Dates with hours,

Anonymous — Fri, 15 Apr 2016 12:48:59 GMT

Hello,

I have in my data model the dates with hours, so there is more than one different value for each day.

This is an issue when I make a table with this date as a dimension, because I have more than one register for each day.

Is it possible group all the registers of one day in one unique value without using the script?

Thank you,

Sara

sunny_talwar — Fri, 15 Apr 2016 17:06:16 GMT

Sure, while you create this in the script, use Floor() function

LOAD Date(Floor(DateField)) as Date

Or you can use the same in the list box expression:

=Date(Floor(DateField))

MarcoWedel — Fri, 15 Apr 2016 22:21:53 GMT

You can also use

DayName(yourtimestampfield) as Date

Regards

Marco