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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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)