Show Top 5 records for each activity

[#1]

Hi All,

Attached is a QVW with sample data which demonstrates the problem that I am having.

In my data model I have 3 fields (Account Name, Activity and Rank). The rank field get assigned a valued based on a business logic. In the UI, dynamically I have to show only best 5 ranks for each activity. That is for Activity 1 I need to show data for the least 5 ranks. We should achieve this via expressions in UI instead of at script level. This is because based on the selections made in the UI, the top 5 records should automatically change.

So I need a method to dynamically show available first 5 rank records.

Could you please help me with this?

Regards,

Murali

[#2]

I forgot to mention.. I am using QV10 SR5.

I believe the dimension limits in introduced in QV11.

[vgutkovsky]

See attached.

Regards,

Vlad

[#4]

Thanks a lot Vlad. It is exactly what I was looking for.

But my badluck is that the user doesn't want to see the rank column. In which case, it it possible to achive this functionality using expressions?

[#5]

I hope this example will answer you question.
I added two charts:


The first contain 3 expressions:

• The first shows how to calculate each row rank.
• The second expression calculates the max value for each row.
• The last is combination of them both - calculates the max only for rows that their rank is in the first 5.

The second chart contains only the last third expression - i hide this column (presentation tab) as u asked.
because null values not shown - you can see only the first five for each application.