create graph on basis of ranking

[#1]

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:

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.

[jonathandienst]

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.

[sunny_talwar · Accepted solution]

Check the attached

3rd chart

Dimension

Awards

Expression

=Sum({<Name = {"=Rank(Count(Awards)) < 2"}>}Sum)

4th chart

Dimension

Awards

Expression

=Sum({<Name = {"=Rank(Count(Awards)) > 2 and Rank(Count(Awards)) < 4"}>}Sum)

[vinieme12]

does Sort by Y-Value not work?

[#5]

Thanks all for the fast responses. The solution of Sunny T works perfectly. I wish I didn't spend 2 days of trying ;-).