How do i create a range of hours from my data set

[#1]

Goodafternoon Community,

I am a starter in Qlikview and am just starting out my with my first(simple) report. I have a data set with time and what i would like to do is to pick out the earliest time and add an hour to it. So basically i will have a range and count the amount of incidents between those two times.

Dimension     Measures

07:00-08:00     10

09:00-10:00     5

11:00-12:00     9

I have attached my qvw and every help/advice is greatly appreciated.

[swuehl · Accepted solution]

If you want to create a field that shows hour values calculated from a time or timestamp field, use Hour() function to transform your data, don't format your time values using Time() function (which will only change the text representation, not the underlying value of the dual value).

Data Types in QlikView

Get the Dates Right‌

Why don’t my dates work?

LOAD

    ...

    Hour(TimeField) as Hour,

    ...

Then you can use the Hour field as dimension and use a distinct count of your incident ID as expression.

[#3]

Stefan,

You are a lifesaver, thank you very much. I am going to read on what you sent me too in order to get better. Have a lovely weekend.