topic Re: Rank an aggregated count in QlikView

Rank an aggregated count

Anonymous — Mon, 29 Jul 2013 11:49:06 GMT

I'm sure this is pretty simple but I cannot seem to get my head around it

I have a variable vCount: aggr (count ({1}race_time),race_distance, temp, altitude)

What I want to achieve is to take the race_time values that make up the aggregate and then rank them from lowest to highest. E.g:

Any help greatly appreciated.

Thanks

Matt

kaushiknsolanki — Mon, 29 Jul 2013 12:15:48 GMT

Hi,

Use the Rank($(vCount))

Regards,

Kaushik Solanki

Kushal_Chawda — Mon, 29 Jul 2013 12:52:48 GMT

Hi,

see the attached application. Hope it will help you

Mon, 29 Jul 2013 13:11:30 GMT

try this

Rank(-1 * aggr (count ({1}race_time),race_distance, temp, altitude))

or in variable try this

Rank(-1 *$(vCount))

Anonymous — Mon, 29 Jul 2013 17:31:17 GMT

Thanks for the reply but I only have QV Personal so cannot view this

Apologies for not specifying this in my original post.

Anonymous — Mon, 29 Jul 2013 17:34:10 GMT

Thanks for the response. Rank($(vCount)) returns:

in the rank field.

If I just specify the variable it displays the correct count so I'm not sure why I'm seeing these results.

Anonymous — Mon, 29 Jul 2013 17:34:51 GMT

Thanks for the response. As with the previous poster these both return:

in the rank field.

If I just specify the variable it displays the correct count so I'm not sure why I'm seeing these results.

Anonymous — Sun, 27 Apr 2014 03:54:27 GMT

Simply give a '-' in front of the variable, vCount: -aggr (count ({1}race_time),race_distance, temp, altitude)

Then use Rank($(vCount))

SunilChauhan — Sun, 27 Apr 2014 04:06:35 GMT

rank(aggr (count ({1}race_time),race_distance, temp, altitude))

hope this helps