Aggregation one column into 3 rang.

[Frankliang]

Hi,

I have an Excel file which I uploaded into Qlik Sense. There is one column called 'Complete_Time'. It includ calculated time records ( how long it took to complete the task in the format 'hh:mm:ss'). 

I am trying to build a Qlik Sense App to show:

The Bar chart will show 3 bars to count the number of rows if:

'Complete Time' <= 3 hrs,

or 3 hrs < 'Complete Time' < 4 hrs,

or 'Complete Time' >= 4 hrs,

Not sure what is best way to do this.

[Saravanan_Desingh]

Try with IntervalMatch, something like below

LOAD * INLINE [
    Start, End, HrsBucket
    00:00:00, 03:00:00, 3_hrs
    03:00:01, 04:00:00, 4_hrs
    04:00:01, 99:99:99, 4+
];

Inner Join IntervalMatch([Complete Time])