16 Replies Latest reply: Nov 2, 2018 4:38 PM by Anca Barbu RSS

    How to get the highest values

    Chia Jia Xiang

      Hi all,

       

      EMPLIDACAD_CAREERSTRMCUM_GPA
      1000477UGRD13200.000
      1000477UGRD13304.750
      1000477UGRD14104.860
      1000477UGRD14204.860
      1000477UGRD14304.820
      1000477UGRD15104.730
      1000477UGRD15204.730
      1000477UGRD15304.740
      1000477UGRD16104.740
      1000477UGRD16204.780

       

      From the table, i want to be able to get the value 4.780, through using the STRM.

       

      So for example, the CUM_GPA for MAX(STRM). ( i tried MAX() , it doeskin work.)

       

      Is there a way to do this in Qlik Sense.

       

      Thank you for your time.