This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
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])