Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Payman
New Contributor

15 minutes interval as dimension

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?

Labels (3)
4 Replies
MVP
MVP

Re: 15 minutes interval as dimension

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Payman
New Contributor

Re: 15 minutes interval as dimension

Thanks for your reply.

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

Untitled.png

 

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
New Contributor

Re: 15 minutes interval as dimension

Anyone could help on this issue?

Partner
Partner

Re: 15 minutes interval as dimension


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

#OnVacation #BetweenJobs.
Please ekskuse my Norglish and Swenglish typos.