topic Re: Aggr & Rank in QlikView

Aggr & Rank

MK_QSL — Fri, 04 Oct 2013 12:34:01 GMT

What is wrong in below code... My idea is to get TOTAL QTY for TOP 10 Customer...but I am not getting any result

=SUM(IF(AGGR(RANK(SUM([Inv QTY])),[Customer Name])<=10,SUM([Inv QTY])))

Re: Aggr & Rank

israrkhan — Fri, 04 Oct 2013 12:49:04 GMT

Hi,

if you are using Straight table, you can use Dimension limits to get it, very simple..

Re: Aggr & Rank

Fri, 04 Oct 2013 12:58:38 GMT

Hi,

You should use the set analysis lke :

= Sum({<FABRICANT_LName= {"=rank(sum([Ventes Unite]), 4)<= 10"}>} [Ventes Unite])

where : FABRICANT_LNAME is the dimension, and Ventes Unite the value sales I want to sum. Here I want to sum up the first 10 manufacturers (Fabricant in french)

if you need to the ranking on a specific period, you should insert a set analysis inside the the rank itself:

= Sum({<FABRICANT_LName= {"=rank(sum( {<Year={2103}>} [Ventes Unite]), 4)<= 10"}>} [Ventes Unite])

Fabrice

Re: Aggr & Rank

MK_QSL — Fri, 04 Oct 2013 13:10:36 GMT

This total I want in text box...

Re: Aggr & Rank

Fri, 04 Oct 2013 13:15:00 GMT

of course

it works in a textbox

just adapt the dimension name and the expression

Fabrice

Re: Aggr & Rank

v_iyyappan — Fri, 04 Oct 2013 13:22:30 GMT

Try like in textbox,

=Sum({<[Customer Name]={"=rank(Aggr(sum([Inv QTY]),[Customer Name]),4)<=10"} >}[Inv QTY])

Regards,

Re: Aggr & Rank

israrkhan — Fri, 04 Oct 2013 13:35:03 GMT

try this, its working with me...

= Sum({<CompanyName = {"=rank(sum(Quantity))<= 5"}>} Quantity)

Contact name is my dimension.

Re: Aggr & Rank

Gabriel — Fri, 04 Oct 2013 13:42:59 GMT

Hi,

I will try

=if(aggr(rank(sum([Inv QTY])),[Customer Name])<=10,Sum([Inv QTY],"Other")

Hope this is helpful

Best Regards,

Gabriel

Re: Aggr & Rank

MK_QSL — Fri, 04 Oct 2013 14:59:44 GMT

What is 4 stand for ?

Re: Aggr & Rank

MK_QSL — Fri, 04 Oct 2013 15:27:28 GMT

Done myself... Thanks to everyone for your help...!!!

=SUM({<[Customer Name] = {"=RANK(AGGR(SUM([Inv QTY]),[Customer Name]))<=10"}>}[Inv QTY])

Re: Aggr & Rank

v_iyyappan — Mon, 07 Oct 2013 10:23:26 GMT

Hi,

you and my expression same. only difference is like

1	Lowest rank on all rows.
2	Average rank on all rows.
3	Highest rank on all rows.
4	Lowest rank on first row, then incremented by one for each row.

Please check it.

regards,