8 Replies Latest reply: Aug 23, 2017 6:28 AM by Andrea Gigliotti RSS

    Ranking of contents

    Chanin D'Souza

      Hello Qlik experts,

      I have the following Data

       

      CrossTable(Year,Score,2)

      Table:

      Load * Inline

      [

      University, Subject, 2014, 2015, 2016, 2017

      A, Sub001, 82, 84, 71, 52

      A, Sub002, 52, 61, 69, 96

      A, Sub003, 74, 84, 89, 53

      B, Sub001, 51, 72, 74, 57

      B, Sub002, 83, 88, 78, 90

      B, Sub003, 98, 58, 76, 71

      C, Sub001, 52, 76, 82, 90

      C, Sub002, 50, 86, 65, 84

      C, Sub003, 74, 99, 87, 86

      D, Sub001, 84, 84, 61, 72

      D, Sub002, 92, 81, 99, 94

      D, Sub003, 51, 71, 71, 96

      E, Sub001, 62, 73, 60, 92

      E, Sub002, 96, 51, 81, 55

      E, Sub003, 55, 75, 81, 72

      F, Sub001, 95, 73, 76, 83

      F, Sub002, 96, 62, 77, 71

      F, Sub003, 93, 92, 74, 60

      ] ;

       

      I require the following output

      IMG-20170822-WA0003.jpg