4 Replies Latest reply: Nov 22, 2016 8:13 AM by perry van der meijden RSS

    create graph on basis of ranking

    perry van der meijden

      Dear all,

       

      I have a database consisting of names, awards and number of awards. If I make a pivot table, it would look like something like the left table:

      Knipsel.PNG

      Creating the first graph in qlikview isn't a problem; the second and third graph are. From the person with the highest number of awards (and the second best) I would like to create a graph with a distribution on different awards. I Tried to do something with aggr() and rank(). I was able to create the graph of the person with the most awards (show top 1), but I failed creating a graph for the second best.

      Any hints and ideas?

       

      regards

      Per.