How can i solve this?

[luiskeyrus]

I would like to make a text object for me to stay fixed the value of this aggregation:

= Num (SUM (aggr (max ({1} [UTs Earrings]), [Application Number])), '###. ###')

But it is not me. Perhaps being a more complex expression, QlikView does not give that option. Thank you.

[sunny_talwar · Accepted solution]

Try this:

=Num(Sum({1} Aggr(Max({1} [UTs Earrings]), [Application Number])), '###. ###')

[luiskeyrus]

Thank you very much Sunny T!!!!   It is works!!!  you are a genius and you have saved my life! hahaha regards from Spain!!!!