Aggregation with set analysis

[dominiksobanski]

Hello, 

I am Iooking for expression wich give me a sum of sales for the first version of deal.

So something like below.

Sum({<version={"=$(min(version))"} >} amount)

But it has to take min version per deal, not the smallest from whole set of data.

I tried to achieve it with aggr function but no luck. 

It has to be dynamic. User can choose eg. range of dates and the calculation has to work. So it is not always the same version of deal for the calculation. 

Is it possible at all? 

[marcus_sommer]

Maybe with something like this:

sum(aggr(sum(Amount) * -(Version=min(Version)), Deal))

[robert99]

@dominiksobanski 

This video might help.

(562) How to use Aggregate (AGGR) chart function & First Sorted Value function in QLIK SENSE - YouTu...

[dominiksobanski]

Thanks for proposal but it is not working.

[dominiksobanski]

Thank you for movie but it didn't answer on my problem.

[robert99]

OK. It worked for me (much to my surprise) in a similar example to the one you described. Where I had previously used script. But good that you found a solution