Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Sum difference between set of records

Hi all,

I have a set of data (which I cannot share, unfortunately) that has a list of times, grouped by a Person column (i.e. person A has times of 06.00, 06.15, 06.30 in Column A (Time1) and times of 07.00, 07.10 and 07.15 in Column B (Time1)

I want to find out the total difference in time between the minimum values for each person (of which there are about 100), so for example, for person A, the difference would be 1 hour (or 60 minutes) as the difference between 06.00 (column A) and 07.00 (the min value of Column B) is 1 hour.

The expression when just looking at one person is just min(Time2) - min(Time1), however this does not work across all records.

How can I do this as a set expression to see TOTAL time across all records?

Thanks very much for reading!

1 Reply
MVP
MVP

Re: Sum difference between set of records

Aggr(Interval(Min(Time2)-Min(Time1),'mm'),Person)