Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dates with hours,

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

1 Solution

Accepted Solutions
sunny_talwar

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))

View solution in original post

2 Replies
sunny_talwar

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

You can also use

DayName(yourtimestampfield) as Date

Regards

Marco