Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ismqui00
New Contributor

Grouping in Dimension

I have a time field, completed_date, that is continuous.  Trying to create a new dimension that groups any time within a certain hour under whatever hour it is.

For example:

10:00:00 - 10:59:59 would be grouped under 10:00

11:00:00 - 11:59:59 would be grouped under 11:00.

Any way to do this?  If so, any example or expression setup?  Thanks in advance.

4 Replies

Re: Grouping in Dimension

Why don't you use the Hour() function 10 to 10:59:59 will all fall under 10th hour of the day....

andrey_krylov
Contributor III

Re: Grouping in Dimension

Or maybe this

=SubField(completed_date, ':', 1) & ':00'

ismqui00
New Contributor

Re: Grouping in Dimension

Using Hour() function shows me sales at that hour, but it groups all days together as well.  Kind of want Hours to be grouped per day, thanks though.  I tried Hour([completed_date])

Re: Grouping in Dimension

May be do this

Floor([completed_date], 1/24)

Community Browser