Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

antonaks
Contributor II

Aggr function?

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).

Untitled.png

I'm Asking for help. Thank you.

1 Solution

Accepted Solutions

Re: Aggr function?

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))

View solution in original post

2 Replies

Re: Aggr function?

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))

View solution in original post

antonaks
Contributor II

Re: Aggr function?

It works! Thank you!