topic Re: Need help to display a value using a text object in QlikView

Need help to display a value using a text object

Thu, 24 Aug 2017 14:10:02 GMT

I'm looking for help in the expression of a text object. How can I do a sum of a field and they display the text of the filed with the highest sum?

ex. Chrome 5,000

Chrome 3,000

IE 1,500

Chrome 1,800

IE 2,200

IE 900

If we sum the values, Chrome has the highest sum and then I want the value of Chrome to be displayed as the text object. Can someone help me with the expression?

Thanks,

Re: Need help to display a value using a text object

sunny_talwar — Thu, 24 Aug 2017 15:34:21 GMT

May be like this

Max(Aggr(Sum(Value), FieldName))

Re: Need help to display a value using a text object

Thu, 24 Aug 2017 15:46:32 GMT

Thanks, it provides the count, but not the field name for some reason.

Re: Need help to display a value using a text object

Peter_Cammaert — Thu, 24 Aug 2017 15:50:54 GMT

=FirstSortedValue(BrowserName, -Aggr(Sum(Value), BrowserName))

Re: Need help to display a value using a text object

sunny_talwar — Thu, 24 Aug 2017 15:52:04 GMT

Look at Peter's response below....

I thought you said you wanted the value of Chrome

Re: Need help to display a value using a text object

Thu, 24 Aug 2017 17:46:43 GMT

Thanks, worked perfect.