Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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))
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)
Anyone could help on this issue?
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))