15 minutes interval as dimension

[Payman]

Hi,

I used Hour(CreateDate) as dimension of the line chart, and everything is ok with the trend lines. Now, there is a requirement to show the chart based on the 15 minutes interval. Is it possible?

[jonathandienst]

Create a rounded time field, rounded to the nearest 15 minutes, and use this as the dimension. To round a Qlik time or date/time value, use:

=Time(Round(TimeField, 15 / 1440))

[Payman]

Thanks for your reply.

Applying your solution made my chart to be shown as the picture below:

While in the hourly base, both lines are shown beside each other. 

For green line the expression is =Count({<CreateDate={">=$(=daystart(today()))<=$(=dayend(today()))"}>} ID) and for red line the expression is =Count({<CreateDate={">=$(=daystart(today()-6))<=$(=dayend(today()-6))"}>} ID)

[Payman]

Anyone could help on this issue?

[Vegar]

When using time you are only formatting the preaentation of a number (such as as timestamp). The numeric value of time(now()) will still be the same as for now()

Try this expression: =Time(Round(frac(CreateDate), 15 / 1440))