Aggregation one column into 3 rang.

Frankliang — Tue, 07 Jul 2020 02:34:17 GMT

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.

Re: Aggregation one column into 3 rang.

Saravanan_Desingh — Tue, 07 Jul 2020 02:48:37 GMT

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

topic Aggregation one column into 3 rang. in App Development

Aggregation one column into 3 rang.

Re: Aggregation one column into 3 rang.