topic Whats wrong with this set analysis? in QlikView

Whats wrong with this set analysis?

richnorris — Fri, 10 Sep 2010 16:28:43 GMT

I am trying to get the top ten clients for a given region, and use it as a dimension. So I have a calculated dimension which is the following:

=if(aggr(rank({<Region = {'EMEA'}>}sum([$(vCurrency) Volume])), [Sales Client]) <=10, [Sales Client])

However, it doesn't seem to make a difference what I change the 'EMEA' in my set analysis to, is there anything glaringly wrong to you more experienced types with what I'm doing here?

Whats wrong with this set analysis?

Miguel_Angel_Baeyens — Fri, 10 Sep 2010 17:52:10 GMT

Hello Rich,

I guess your set analysis should go in your sum expression

=if(aggr(rank(sum({< Region = 'EMEA' >} [$(vCurrency) Volume])), [Sales Client]) <= 10, [Sales Client])

Regards.

Whats wrong with this set analysis?

vgutkovsky — Sat, 11 Sep 2010 00:59:32 GMT

Yep, Rank does not take set analysis so you would need to either put it in your inner expression or put an IF statement on the outside.

Edit: Also, your AGGR should be on the outside and the IF should be on the inside: aggr(if(rank(sum(..))<=10,...),_____)

Regards,