topic firstsortedvalue in QlikView

firstsortedvalue

Sat, 22 Sep 2012 18:14:54 GMT

I am using this expression below to retrieve the last amount corresponding my selection criteria and it is working fine when i select one client

firstsortedvalue({<Year={'$(vMaxYear)'},Date={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>}Amount,-Date)

My problem i don't knwow how can i have the sum of all clients ?

Can you help me Please

It is very Urgent.

Slim.

whiteline — Sat, 22 Sep 2012 19:15:09 GMT

Hi.

To iterate through all clients you can use aggr() function. Then use sum(), with set expression if needed.

For example:

=Sum(aggr(firstsortedvalue(...), Client))

Sat, 22 Sep 2012 19:26:55 GMT

Hi,

Many Thanks , it is working very well.

Regards,

Slim.