Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Volume by hours in Day

Hi All,

I need to calculate the volume of occurrences that take place by hour in a 24 hour clock, disregarding the day month and year associated with the time stamp. I am trying to establish a trend for these occurrences. Displaying this in a bar chart would be preferable. I read through a couple of discussion questions but, have not found precisely what I am looking for.

Thank you for the help in advance.

3 Replies
regowins
Creator II
Creator II

Hi Joseph,

Not sure I fully understand your question without an example of what you are trying to do. I have attached an example of a simple chart with hour /volume.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

It would be better to calculate some values up-front in your load script, but it can also be done in the UI using objects and simple expressions. I'm assuming that your occurrences are available in an internal table and each have an ID (called OccurenceID) and a timestamp (called OccurrenceTimestamp).

Create a bar chart with (calculated) dimension =hour(OccurrenceTimestamp) and expression =count(OccurrenceID).

Best,

Peter

jagan
Luminary Alumni
Luminary Alumni

Hi,

In script create an additional column for hour like below

LOAD

*,

Hour(OccurenceDateTime) AS Hour

FROM DataSource;

Now in chart try like below

Dimension: Hour

Expression: Sum(Volume) or Count(SomeID)

Hope this helps you.

Regards,

jagan.