topic Chart hover-text in QlikView

Chart hover-text

Thu, 18 Jul 2013 21:10:51 GMT

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))

Re: Chart hover-text

jolivares — Fri, 19 Jul 2013 02:02:43 GMT

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

Regards.

Re: Chart hover-text

rwunderlich — Fri, 19 Jul 2013 05:08:01 GMT

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

Re: Chart hover-text

rwunderlich — Fri, 19 Jul 2013 06:25:53 GMT

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

Re: Chart hover-text

Fri, 19 Jul 2013 16:44:51 GMT

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