topic Aggr function? in QlikView

Aggr function?

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

Hello everybody.

I nave a issue with aggr function. Example is attached.

I need to show sum of value data in the table for latest and earliest Timestamp by Clients.

But when I use set analysis I have only one value (max or min from all data set).

I'm Asking for help. Thank you.

sunny_talwar — Thu, 10 May 2018 15:45:37 GMT

Try these expressions

Timestamp(Min([Time of SnapShoot]))

Timestamp(Max([Time of SnapShoot]))

FirstSortedValue(Aggr(Sum(Value), [Time of SnapShoot], Name), Aggr([Time of SnapShoot], [Time of SnapShoot], Name))

FirstSortedValue(Aggr(Sum(Value), [Time of SnapShoot], Name), -Aggr([Time of SnapShoot], [Time of SnapShoot], Name))

antonaks — Thu, 10 May 2018 19:58:21 GMT

It works! Thank you!