topic Re: Need set expression in QlikView

Need set expression

Chinnu3 — Mon, 17 Apr 2023 10:13:31 GMT

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.

Re: Need set expression

Kushal_Chawda — Mon, 17 Apr 2023 15:03:38 GMT

@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

Re: Need set expression

Chinnu3 — Tue, 18 Apr 2023 12:54:48 GMT

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.

Re: Need set expression

Kushal_Chawda — Tue, 18 Apr 2023 13:37:11 GMT

@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