topic Rank by Conference in QlikView

Rank by Conference

bbi_mba_76 — Tue, 11 Nov 2014 16:43:11 GMT

Hi,

in the attached pivot I want an expression to calculate the rank by conference, ie in Eastern Conf. Toronto should be the first and Philadelphia the last one.

Could you help me? Thanks

Re: Rank by Conference

Tue, 11 Nov 2014 16:57:39 GMT

According to this thread, you might need to change to table (I already did, it ordered them by Conference then Rank), so that would be an easy solution.

Re: Rank by Conference

bbi_mba_76 — Tue, 11 Nov 2014 17:02:10 GMT

I would like to have the expression, so if I select two divisions of the same conf I have the related rank.

Re: Rank by Conference

rubenmarin — Tue, 11 Nov 2014 17:07:06 GMT

Hi Michele, you can try with:

Aggr(rank(total sum({<Conference={'Western Conference'}, Division=,Team=>} W/(W+L)),4,1), Conference, Division, Team)

& Aggr(rank(total sum({<Conference={'Eastern Conference'}, Division=,Team=>} W/(W+L)),4,1), Conference, Division, Team)

Re: Rank by Conference

jerem1234 — Tue, 11 Nov 2014 20:23:22 GMT

Try:

aggr(rank(sum({<Division=,[Team]=>} W/(W+L)),4,1), Conference, Team)

Hope this helps!