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:
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.
I suggest that you upload a small sample qvw which includes the first graphs for more specific and accurate suggestions one how to achieve the last. Briefly, though, you should be able to select the second ranked using a rank expression.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein