Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Frankliang
Contributor
Contributor

Aggregation one column into 3 rang.

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.

 

1 Reply
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])