Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Top performance

Hello everyone,

step 1 : from the table below i want to get for each field the best student in it  (with the highest note) i.e : Math->Student1 and 4, History-> Student2...

StudentfieldNote
Student 1Math9
Student 1HISTORY5
Student 1SPORT7
Student 2Math3
Student 2HISTORY10
Student 2SPORT8
Student 3Math6
Student 3HISTORY7
Student 3SPORT5
Student 4Math9
Student 4HISTORY8
Student 4SPORT9

step 2 : by selecting a student from the list i want to get only fields in witch he is has the highest note comparing to his friends i.e when if i select Student 1 i should have only Math, Student 4-> Math and SPORT...

any idea ?

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Maybe like attached?

You can hide columns of the straight table chart in presentation tab as needed.

View solution in original post

3 Replies
Highlighted
MVP
MVP

Maybe like attached?

You can hide columns of the straight table chart in presentation tab as needed.

View solution in original post

Highlighted

HI

Try like this

Highlighted
Creator III
Creator III

worked as i expected.

Thank's a lot.