how to show the max subject in textobject in qlikview

[marjan_it]

!

I want to show the max subject value in the textobject. when I use this expertion "max( aggr( count([FacilityTypeParentID]), FacilityTypeParentID ))" Its show the count of the max value but I want to show the name of max value. means FacilityTypeParentname.

notify I want to show in a textobject not in a chat.

[#2 · Accepted solution]

You should write script in "text"  part in textObject and to use the scrip like this:

=' Max is:   '&  max() & 'and name is : ' & FacilityTypeParentname