Skip to Content
0

Rank issues in web intelligence

Oct 31, 2016 at 01:12 PM

89

avatar image

Experts

While apply ranking on a table and apply filter to show top 5 then it works fine however when there's a duplicate rank value ( more than 2 or 3 ) how can we limit to show top 5 rows only ?

I've tried with few variations but unable to solve it -

i.e., for the following table 01 - I have type as dimension and value as measure , created a variable to calculate the rank then applied filter on the variable to show top 5 ( less than or equal)- works fine.

however, if I have the rank value 1,2,3,3,3,4 how can i show the top 5 rows ? or if i have rank values as 1,2,3,4,5,5 - again how to achieve to show top 5 rows only?

These are the ways I have tried -

> Runningcount(type) (output - 1 or 1 ) to count the number of rows then apply filter on to show when value is 1 but as I have already a rank filter hence this additional filter doesn't work.

> another way i have tried - added another column to see if the previous rank is same as the current rank .. if yes then ++1 for the new rank ..then applied filter again on the table but doesn't work.

Table - 01

Type | value | var_rank_value = rank(value;[type])

--- ----- ----------------------

Green 12 1

Blue 11 2

Brown 10 3

Black 9 4

Orange 5 5

Yellow 2 6

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Oct 31, 2016 at 01:57 PM
0

try with these steps.

var_rank_value = rank(value;[type])

Apply rank filter to see the top 5 values.

Create one more variable Show/Hide=RunningCount([Rank];([var_rank_value]))

Apply filter on Show/Hide variable where values are equal to 1.

Share
10 |10000 characters needed characters left characters exceeded