Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

balajisj30
New Contributor III

Nested Aggregation not allowed - Error

Hello People

I want to sort Sum(revenue)/Sum(census) based on expression. I have written the below expression in the sorting pane.

Sum({<id_description = {"=Rank(Sum(revenue)/Sum(census))<=10"}>} Sum(revenue)/Sum(census))

But i get an error as (Nested Aggregation not allowed). Please help me to solve this issue.

Thanks

Balaji

5 Replies
agigliotti
Honored Contributor II

Re: Nested Aggregation not allowed - Error

in which way you'd like to order the output?

devarasu07
Honored Contributor II

Re: Nested Aggregation not allowed - Error

Hi,

You can try with sortable aggregation method (this feature available Qv12 & above version)

The sortable Aggr function is finally here!

Aggr(Sum({$<id_description = {"=Rank(Sum(revenue)/Sum(census),4)<=10"}>} revenue/census),

( id_description, (=Sum({<id_description>} revenue/census), DESC)))


Thanks,Deva

balajisj30
New Contributor III

Re: Nested Aggregation not allowed - Error

Sort based on values of [Sum(revenue)/Sum(census)] - desending.

agigliotti
Honored Contributor II

Re: Nested Aggregation not allowed - Error

which chart object are you using to sort as requested ?

Re: Nested Aggregation not allowed - Error

Try this

Sum({<id_description = {"=Rank(Sum(revenue)/Sum(census))<=10"}>}revenue)/Sum({<id_description = {"=Rank(Sum(revenue)/Sum(census))<=10"}>}census)

Community Browser