topic Re: Show top 3 values per first dimension in QlikView

Show top 3 values per first dimension

nesonica — Sat, 16 Nov 2024 21:01:55 GMT

Hi guys,

I am failing at building the TOP3-dimension with the formula

=If(Rank(Sum(TOP3-Category)) <=3, Sum(TOP3-Category))

as it would take ages to process all values. The plan is a table like this here:

Thanks in advance! Best regards.

Nes

asinha1991 — Wed, 17 Apr 2019 18:51:51 GMT

put the second calculated dimension as

=aggr(if(rank(sum(sales))<=3,[Category]),[Customer],[Category])

asinha1991 — Wed, 17 Apr 2019 18:53:33 GMT

attaching qvw, i used your data set and showed top 2 out of it, look at the top 2 pivot in qvw

nesonica — Thu, 25 Apr 2019 11:09:24 GMT

thanks so much but unfortunately i have no permission qvw. could you please explain? 🙂

asinha1991 — Fri, 26 Apr 2019 05:30:28 GMT

create a straight table or pivot chart with two dimension

1. Customer

2.=aggr(if(rank(sum(sales))<=3,[Category]),[Customer],[Category]) (make sure field names are correct)

In expression

add your measure(sum(sales) for example)