Skip to main content
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Aikh
Contributor

Dynamic row-based calculation

Hi everyone!

I'm trying to calculate the H-Index for a set of data where H-Index of x means that an individual has x entries each with at least x cites (a score).

In the dataset below: 

Aikh_0-1615519165897.png

The overall H-Index would be 6 (there are at least 6 entries in the table above each with cite value of 6 or above) and the H-Indexes for A and B would be 5 and 4 respectively.

I'm able to compute the overall using a measure:

Count( DISTINCT aggr( NODISTINCT if(Cites.Cites>=NUM(RANK(TOTAL Cites.Cites,4,1)),[Entry]),[Entry])) 

However, each row only shows the share of counts for the total.

I would like each row to be updated with the correct H-Index for each person.

Is there any way I can achieve this?

Aikh_1-1615519248503.png

 

Labels (1)
0 Replies