Nested aggregation not allowed

[georgeD]

Hi every one

I wrote the code below but there is an error :Nested aggregation not allowed

sum({<[cust]={"=Rank(sum({<[product.cat]={'7070'}>} [sales]))<=10"} >} sum({<[product.cat]={'7070'}>} [sales]))

what can i do

thanks in andvance

[vinieme12 · Accepted solution]

As below

sum({<

[cust]={"=Rank(sum({<[product.cat]={'7070'}>} [sales]))<=10"}

,[product.cat]={'7070'}

>} [sales])

[georgeD]

Thank you very much. It is ok.

may you write how could i sort it ?

[vinieme12]

If you are using [cust] as dimension then choose sort by expression and use your rank expression

=Rank(sum({<[product.cat]={'7070'}>} [sales]))

[georgeD]

i m using [cust ] as dimension and i  want to sort it descending based on the previous code.

Sorry for all  this, im using qlik only few days and im confuse a litle bit.

Thanks in andvance