Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
JVET
Contributor
Contributor

Sum-Aggr-FirstSortedValue Problem

Hello. I´m usig sum(Aggr(FirstSortedValue(acum_margen_bruto,-mes_mg_bruto),mes_alta))-(14.51*(max(clientes,mes_alta)))  and this expression is not doing what I need and dont know how solve it.

Qlik-ejemplo mal1.JPG

Single amounts ar correct, but Total amount is incorrect.  How can I solve.

 

Thanks.

2 Replies
JVET
Contributor
Contributor
Author

Any idea? Thanks

marcus_sommer
MVP & Luminary
MVP & Luminary

You may need another sum(aggr()) wrapping your expression.

- Marcus