topic Re: Finding a Rank in QlikView

Finding a Rank

Mon, 03 Feb 2014 12:58:06 GMT

hi all

i want to find out Rank of Sales according State without Taking State as dimension in Table

am attaching QVW file And data File

i have Find out by including State dimension in Table

is it possible???

Finding a Rank according to that Dimension Without including That dimension in Table

Thanks in Advance

Re: Finding a Rank

MK_QSL — Mon, 03 Feb 2014 13:01:46 GMT

Aggr(Rank(SUM(Sales)),Person,State)

Re: Finding a Rank

sundarakumar — Mon, 03 Feb 2014 13:13:52 GMT

Hi,

PFA,

Add

=aggr(rank(sum(Sales)),State)

as expression , if you use it as expression you will see it is shown only once for every state,

if you want to show it in every coloum plese use the same in the calculated dimension.

-Sundar

Re: Finding a Rank

jerem1234 — Mon, 03 Feb 2014 13:16:07 GMT

You're trying to replicate the rank when you add State as your dimension on your table? Then you want to go with Manish Kachhia's formula but with Person and State reversed:

Aggr(Rank(Sum(Sales)),State,Person)

You might also want to rank each state without Person in consideration using the formula:

Aggr(Nodistinct Rank(SUM(Sales)),State)

Please find attached.

Hope this helps!

Re: Finding a Rank

Mon, 03 Feb 2014 13:42:04 GMT

Thanks jerem for Your Fast reply

Re: Finding a Rank

sunilkumarqv — Mon, 03 Feb 2014 13:44:42 GMT

Hi,

check this

Aggr(Rank(Sum(Sales)),State,Person)