topic Re: How can i solve this? in QlikView

How can i solve this?

luiskeyrus — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 27 Oct 2016 16:55:23 GMT

Try this:

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

luiskeyrus — Fri, 28 Oct 2016 07:27:22 GMT

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