New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
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

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

Re: 15 minutes interval as dimension

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)

New Contributor

Re: 15 minutes interval as dimension

Anyone could help on this issue?

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.