Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
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

Tags (2)
2 Replies

Re: Get Max and Min from A Table

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

MVP
MVP

Re: Get Max and Min from A Table

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.