topic 'Detach' the rank function..maybe with set analysis? in QlikView

'Detach' the rank function..maybe with set analysis?

Thu, 19 Aug 2010 09:48:45 GMT

I have a problem with the rank function. The behaviour I need in the sample file attached is as follows:

- Person 'N' is ranked 9th when no selections are made

- If I select Person 'N' then his rank changes to 1st (as the data set is now just one person)

- However, I need chart object CH64, to show his rank assuming no selections had been made

Is that possible?

Thanks in advance!

'Detach' the rank function..maybe with set analysis?

Thu, 19 Aug 2010 10:30:04 GMT

Hi,

Please find the attched sample file.

Regards,

Ravi

'Detach' the rank function..maybe with set analysis?

Thu, 19 Aug 2010 10:39:04 GMT

Thanks Ravi.

Is it possible to have object CH64 show ths rank though OR is it possible to have all the other rows in the main chart hidden except the one selected?

For example, if I select person E then CH64 shows '1' where as I want it to show '15'. Possible?

'Detach' the rank function..maybe with set analysis?

johnw — Fri, 20 Aug 2010 00:15:03 GMT

This works in both objects:

aggr(rank(sum({1}Points)),Person)

Though you may want this, as it should respect all of the other possible selections. For instance, if you had a date field on which you earned points, and you selected this year, you probably want the rank of the person this year, not for all years.

aggr(rank(sum({<Person=>}Points)),Person)

'Detach' the rank function..maybe with set analysis?

Fri, 20 Aug 2010 01:38:41 GMT

John, that's absolutely fantastic. Thanks a lot for your help!