topic Re: Aggr or Set Expression? in QlikView

Aggr or Set Expression?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Computer_ID	Date_Used	Time_used(hours)	User_ID
1	10/10/2017	2	rEyp
1	10/10/2017	2	J83x
1	10/10/2017	6	DnkF
2	10/10/2017	2	3PKS
2	11/10/2017	4	MDLf
1	12/10/2017	4	gqMB

Assuming I have the table from above, I need the sum of the Time_used for each Computer_ID, by taking the maximum possible amount per day.
In the above-mentioned case, the output should be something like:

Computer_ID	Sum_Time_used
1	10(6+4)
2	6

The question is: Should I use the aggr function or make a set expression in a sum()? Also, can you give me an example of how should I use the said function in the given example?

Re: Aggr or Set Expression?

tresB — Wed, 27 Dec 2017 07:50:58 GMT

May be like:

=Sum(Aggr(Max(hours), Date))

Re: Aggr or Set Expression?

luismadriz — Wed, 27 Dec 2017 08:14:21 GMT

Hi, I think it should be like this:

=Sum(Aggr(Max([Time_used(hours)]), Computer_ID,Date_Used))

Re: Aggr or Set Expression?

Anonymous — Wed, 27 Dec 2017 08:26:56 GMT

That's about it, thanks!