Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
balajisj30
Creator
Creator

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
Partner - Master III
Partner - Master III

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

devarasu07
Master II
Master II

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
Creator
Creator
Author

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

agigliotti
Partner - Master III
Partner - Master III

which chart object are you using to sort as requested ?

sunny_talwar

Try this

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