topic Rank Within a Dimension in QlikView

Rank Within a Dimension

Sun, 02 May 2010 18:41:11 GMT

I created buckets to get the sales of the top X number of clients in a chart using the following expression.

if (BuckettA = 'Top10', sum({$<Year={2009},Customer = {"=rank(sum({$<Year={2009}>}Sales)) <= 10"}>} Sales)/sum({<Year={2009}>}Sales),

if(BucketB = 'Top20', sum({$<Year={2009},Customer = {"=rank(sum({$<Year={2009}>} Sales)) <= 20"}>} Sales)/sum({<Year={2009}>}Sales),

if(BucketC = 'Top30', sum({$<Year={2009},Customer = {"=rank(sum({$<Year={2009}>} Sales)) <= 30"}>} Sales)/sum({<Year={2009}>}Sales),

null())))

I layered a dimension of Salesgroups onto the expression above.

The result I'm getting is that all the SalesGroups are pulling the TOP 10/20/30 RANK FOR ALL OF 2009 across ALL SALESGROUPS instead

of the top 10/20/30 RANK WITHIN THE SALESGROUP.

Can someone point out to me how I can adjust/change my expression above to make the ranks within each bucket apply WITHIN THE DIMENSION SalesGroup?

Thank you in advance...

Rank Within a Dimension

fernandotoledo — Sun, 02 May 2010 22:12:46 GMT

I didn't exactly what you are trying to do. What type of chart are you creating? Is the Customer a visible dimension in the chart? The expression seems ok, but too complex! Try using this sequence SUM( {$...} IF( Bucket..., Sales))

Rank Within a Dimension

fernandotoledo — Sun, 02 May 2010 22:12:56 GMT

I didn't get exactly what you are trying to do. What type of chart are you creating? Is the Customer a visible dimension in the chart? The expression seems ok, but too complex! Try using this sequence SUM( {$...} IF( Bucket..., Sales))