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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
ks20
Contributor III
Contributor III

Top 20 based on measure value

Hi All,

I need Top 20 records based on measure value in table view.
1 dimension and 3 measures.
Dimension: Customer

Measure 1: Calls

Measure 2: Total Calls

Measure 3: Conversion %

Need top 20 based on Measure 3, though I got top 20 using this formula

If(Rank(measure, 1, 0) <= 20,measure)
Using this formula I get top 20 but I also get null values for rest of the records, how do I remove thoes nulls values and only showcase top 20 records.

Thank you in advance!

Labels (5)
10 Replies
BrunPierre
Partner - Master II
Partner - Master II

@premacharya0903 Like this ?

= Aggr ( If(Rank(measure, 1, 0) <= 20, Customer, 'Others') , Customer)