Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ninnartx
Creator
Creator

Top N reflected on other charts as well

Hi all,

I want the top N from one chart to be associated to another chart as well.

For example, if I have a bar graph and the users could input their own dimension limit using input box and a variable, I would like the result to be reflected on another chart as well.

For example, if I were to select Top 3 students for the bar chart, I would like their average score to be displayed on another chart.

Since I'm not actually making a selection and am using dimension limits to limit the Top N number, I can't figure out how to link them.

Any help would be appreciated! Thank you

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You can't really link the charts, but you can use set analysis in your second chart to limit the field values according your first chart.

Something like

=Avg({<Student= {"=Rank(Avg(Score))<=3"}>} Score)

If you need more help, post your complete dimensions and expressions you are using in both charts.

Or upload a small sample QVW.

View solution in original post

1 Reply
swuehl
MVP
MVP

You can't really link the charts, but you can use set analysis in your second chart to limit the field values according your first chart.

Something like

=Avg({<Student= {"=Rank(Avg(Score))<=3"}>} Score)

If you need more help, post your complete dimensions and expressions you are using in both charts.

Or upload a small sample QVW.

View solution in original post