QlikView - Get Value of top 1 into Text Object

[Anonymous]

Hi guys,

I have list of Codes for a metric called Sales.

In a table I can put the rank of each code, based on Sum(Value).

Now I want to put the Sum(value) of the top1 into a text object.

But in my filters I have to select:

- Month Year;

- Code;

- Metric.

I want to show the top 1 value, ignoring the filter Code.

Giving you a context:

I have the above table, when I select Metric and MonthYear:

My top 1 Sum(value) is Code=1295.

So when I add a selection in Code = 604, I want to show in a text object the value of the top 1, corresponding to the filters I'm applying, except Code.

I've attached a qvw sample. Please see Sheet Rankings.

Thanks in advanced,

Sílvia

[vishsaggi]

Got it. Thanks for that Sunny.