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: 
Anonymous
Not applicable

How do I find out where the best students are and how to compare cities for success?

Hi, I'm a beginner and I do not get the best. I still learn how the program works and I need help.

I have two tables

1.Student with columns index number, subject Id and grade

2. and table Exam with columns index number, name. surname, address and city

 How do I find out where the best students are and how to compare cities for success?

Help me, it's urgent. thank you.

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

just create two bar chart 

one 

dimension FisrstName & Surname 

expression avg(grade)

this will rank the students 

second :

dimension city 

expression avg(grade)

this will grade the cities 

Anonymous
Not applicable
Author

I didnt define first question exactly. How to make table to show where the best student live? In witch city.