Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
marjan_it
Contributor III

how to show the max subject in textobject in qlikview

!

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.

1 Solution

Accepted Solutions
Not applicable

Re: how to show the max subject in textobject in qlikview

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

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

View solution in original post

1 Reply
Not applicable

Re: how to show the max subject in textobject in qlikview

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

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

View solution in original post