Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Aikh
Contributor
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