Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart hover-text

I have a chart which plots highest, lowest, and average percentages by grade on a line graph.

Each data point plotted in the highest and lowest lines is a specific school district (whichever happens to be the highest or lowest in that grade).

What I'm looking for is some way to identify, ideally within the hover-text, which school district it is that's holding the highest or lowest 'record' for that data point.

My expression for highest is

max(aggr(sum(Truant)/sum(StudentCount), Grade, District))

and lowest is

min(aggr(sum(Truant)/sum(StudentCount), Grade, District))

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Attached is a sample using popups. The hover shows both high and low districts. I haven't figured out how to display just the relevant district -- high when hovering on the high line -- and still maintain your values on data points.

-Rob

View solution in original post

4 Replies
jolivares
Specialist
Specialist

Try to add text inside the graph and see the document attached...

Regards.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The expression to identify the District with the highest rate by Grade would be:

aggr(NODISTINCT

  FirstSortedValue(District,

    -aggr(sum(Truant)/sum(StudentCount), Grade, District)

  )

,Grade)

and the lowest would be the same without the "-" on the second aggr.

aggr(NODISTINCT

  FirstSortedValue(District,

    aggr(sum(Truant)/sum(StudentCount), Grade, District)

  )

,Grade)

I'll have to play with it a bit to get the hovers to display correctly on a line chart. Maybe you'll figure it out before I do,

-Rob

http://masterssummit.com

http://robwunderlich.com

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Attached is a sample using popups. The hover shows both high and low districts. I haven't figured out how to display just the relevant district -- high when hovering on the high line -- and still maintain your values on data points.

-Rob

Not applicable
Author

Brilliant! That's perfect, thanks so much Rob!