topic Re: Set Analysis with Rank in QlikView

Set Analysis with Rank

javier_florian — Wed, 25 Nov 2020 16:16:04 GMT

Hello Pals,

I have a complex set analysis to show dynamic top ten according a dimension, when I tried to show the first one I set the follow expression and works fine:

Sum({<[Partner]={"$(=Aggr(If(Rank(Total Aggr((Sum({<Flag-={'BUDGET'}>}SumaDeValor)),

[Partner]))=1,[Partner]),[Partner]))"}>}SumaDeValor)

However, if I tried to show "Others" with the condition different to top 10, that didn't work:

Sum({<[Partner]={"$(=Aggr(If(Rank(Total Aggr((Sum({<Flag-={'BUDGET'}>}SumaDeValor)),

[Partner]))>10,[Partner]),[Partner]))"}>}SumaDeValor)

Any explication? How can I fix the set expression to work correctly?

Regards,

Re: Set Analysis with Rank

vishsaggi — Thu, 05 Jul 2018 20:45:14 GMT

Can you share your sample file with an expected output?

Re: Set Analysis with Rank

Anil_Babu_Samineni — Fri, 06 Jul 2018 03:43:24 GMT

May be this? and you can use Others option enabled

Sum({<[Partner]={"=Rank(SUM({<Flag-={'BUDGET'}>} SumaDeValor))>10"}>}SumaDeValor)

Sum({<Flag-={'BUDGET'}, [Partner]={"=Rank(SUM({<Flag-={'BUDGET'}>} SumaDeValor))>10"}>}SumaDeValor)

Or else

=IF(Aggr(Rank(SUM({<Flag-={'BUDGET'}>} SumaDeValor)),Partner)>10,Partner)

And expression

Sum(SumaDeValor)

Re: Set Analysis with Rank

sunny_talwar — Fri, 06 Jul 2018 13:15:25 GMT

Where exactly are you trying to show this? What is your dimension for the chart?

Re: Set Analysis with Rank

javier_florian — Fri, 06 Jul 2018 19:59:53 GMT

Was I in a loop mental analysis? hahaha