topic Re: Rank? in QlikView

Rank?

Thu, 05 Mar 2015 12:04:43 GMT

Hi Folks,

I have a Fileds like below.

ID,Name,Volume is (sum(Volume))

here I want top 10 ID's only who is having max volume

Rank-- ID-- Name-- Volume

1 5 D 500

2 9 X 470

3 8 Y 420

----------------------------------

10 2 C 301

I want top 10 ID's Please help me in this?

I tried this it's not working

rank(sum({<Period = {'>$(=date(max(Period))-$(vTrendingDays)) <=$(=date(max(Period)))'},day={'Y'}>} Volume))<=10

Re: Rank?

anbu1984 — Thu, 05 Mar 2015 12:06:55 GMT

Do you want top 10 IDs in a Text box?

EDIT: =Concat(If(Aggr(Rank(Sum(Volume)),ID)<=10,ID),',')

Re: Rank?

MK_QSL — Thu, 05 Mar 2015 12:08:46 GMT

Provide sample data please.. or look into below example...

Rank function in calculated dimension

Re: Rank?

MayilVahanan — Thu, 05 Mar 2015 12:11:39 GMT

'>$(=date(max(Period))-$(vTrendingDays)) this part gives number instead of date.

May be try like this.

'>$(=date(max(Period)-$(vTrendingDays)))

and also check the date format are same with Period date format.

Re: Rank?

Thu, 05 Mar 2015 12:30:43 GMT

I want Top 10 Volume's.

Just assume above i have given the sample data just like that only i want it.

Re: Rank?

anbu1984 — Thu, 05 Mar 2015 12:38:35 GMT

Top 10 IDs

=Concat(If(Aggr(Rank(Sum(Volume)),ID)<=10,ID),',')

Top 10 Volume

=Concat(If(Aggr(Rank(Sum(Volume)),ID)<=10,Aggr(Sum(Volume),ID)),',')

Re: Rank?

simenkg — Thu, 05 Mar 2015 12:48:52 GMT

sum({<ID={"=Rank(Sum(Volume))<=10"}>} Volume)

Re: Rank?

Thu, 05 Mar 2015 13:16:19 GMT

I don'y want in text object.

I want it in a straight table

Re: Rank?

kamielrajaram — Thu, 05 Mar 2015 13:19:57 GMT

Hi Shravan,

Expression with the rank function =rank(expression,ID)

Then on the Presentation tab tick Max Number box and type 10 in the box

Regards

Kamiel

Re: Rank?

anbu1984 — Thu, 05 Mar 2015 13:31:50 GMT

If(Aggr(Rank(Sum(Volume)),ID)<=10,Aggr(Sum(Volume),ID))

Re: Rank?

Thu, 05 Mar 2015 13:37:14 GMT

why don't you simply use "Dimension Limits" tab, and set only 10 values based on sum(volume) expression ?

best regards

Chris