Need set expression

[Chinnu3]

Hi All,

I have 3 columns

Unique ID, Classification, Value 

It has 200k records,

I want to show in frontend like top 10 Values based on Classification (like each classification i want to show top10 vales only) and total I have 15 Classification, So i need to show 150 Top values over all.

Thanks in advance. 

[Kushal_Chawda · Accepted solution]

@Chinnu3  create table

Dimension: Classification, Unique ID

Measure:

=sum(aggr(if(rank(sum(Value),4)<=10, sum(Value),0),Classification, Unique ID))

Note:  Uncheck Suppress zero values option in presentation tab

[Chinnu3]

Hi Kushal,

It is working but can you elaborate, this set expression please. and why you have used this 4 in this.

sum(aggr(if(rank(sum(Value),4)<=10, sum(Value),0),Classification, Unique ID))

Thank you.

[Kushal_Chawda]

@Chinnu3  you can read the documentation from Qlik help. That has detailed on all the parameters which you can update according to your ranking requirement