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

Get Max and Min from A Table

Please find below logic which will help

  1. If you have a Table of Data
  2. You would want to get Max and Min for each Row, among all Columns.

GetMaxMinFromRow.png

2 Replies
sunny_talwar

Would you be able to share the sample file you are working with (if there is one)?

swuehl
MVP
MVP

Consider transforming the table from a cross table to a straight table:

The Crosstable Load

basically creating a table with Student, Subject, Mark fields

Then use Max(Score) / Min(Score) and FirstSortedValue(Subject, -Score) / FirstSortedValue(Subject, Score) as expressions in a table chart with dimension Student.