topic Re: How to make conditional sum in QlikView

How to make conditional sum

Wed, 12 Sep 2012 17:03:08 GMT

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.

Re: How to make conditional sum

Jason_Michaelides — Wed, 12 Sep 2012 18:19:43 GMT

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

Re: How to make conditional sum

Wed, 12 Sep 2012 19:22:23 GMT

yes!

Re: How to make conditional sum

Jason_Michaelides — Wed, 12 Sep 2012 19:32:22 GMT

Try

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

Jason

Re: How to make conditional sum

Wed, 12 Sep 2012 19:52:00 GMT

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

Re: How to make conditional sum

Jason_Michaelides — Wed, 12 Sep 2012 20:31:59 GMT

Can you post your app?

Re: How to make conditional sum

Wed, 12 Sep 2012 20:42:40 GMT

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.

Re: How to make conditional sum

Thu, 13 Sep 2012 17:27:35 GMT

Hello,

I tried your solution and didnt work

Thank you

Re: How to make conditional sum

Jason_Michaelides — Thu, 13 Sep 2012 20:01:18 GMT

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.