Re: How to make conditional sum - Qlik Community

Report Inappropriate Content · ‎2012-09-12

DATE	NAME	KIND OF ACTIVITY	STAR ACTIVITY	STATUS	EQUIP NAME	TOTAL TIME
31-8-12	HELMAN	M.P	22:00	OK	BTA 1	05:00
31-8-12	ANDRES	M.P	23:00	OK	BTA1	05:00
1-9-12	WILMAR	EMERGENCY	08:00	PENDING	BTA2	01:00
1-9-12	LEOANRDO	TEST	07:00	PENDING	BTA2	05:00

In a past question i needed to count the number of activities and that doubt was solved with this:

=Count({$<Status={"OK"}>}Distinct [Kind of Activity]&[Fecha]&[Equipment Name])

now i need to obtain the sum of activities time that is consigned in the TOTAL TIME column, for example i want to obtain the total time for M.P (KIND OF ACTIVITY column), in the example the result will be 05:00, because i have two records but that is only one activity.

I hope you can help to do that.

Sorry for my english.

Jason_Michaelides · ‎2012-09-12

If "Kind of Activity" is the same, will the "Total Time" always be the same?

Report Inappropriate Content · ‎2012-09-12

yes!

Jason_Michaelides · ‎2012-09-12

Try

Max(Total <[KIND OF ACTIVITY]> [TOTAL TIME])

Jason

Report Inappropriate Content · ‎2012-09-12

hello,

I tried your solution and didnt work, this only show me the bigest value on the table, and i need that show the sum of the total time for each activity.

Thank you

Best Regards

Jason_Michaelides · ‎2012-09-12

Can you post your app?

Report Inappropriate Content · ‎2012-09-12

It sounds like you just want a sum of total time per activity, but that would give you a total of 10 hours for M.P. and you said you wanted it to show 5:00. Here is an example of both ways.

Report Inappropriate Content · ‎2012-09-13

Hello,

I tried your solution and didnt work

Thank you

Jason_Michaelides · ‎2012-09-13

You need to provide more information. If Total Time is always the same for each Event then my solution with Max or Avg or Only should be fine. Please either post your app or at least some sample data with an example of output.