topic Re: Nested aggregation not allowed in QlikView

Nested aggregation not allowed

georgeD — Sat, 07 May 2022 13:48:13 GMT

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 — Sat, 07 May 2022 17:29:44 GMT

As below

sum({<

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

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

>} [sales])

georgeD — Sat, 07 May 2022 17:46:05 GMT

Thank you very much. It is ok.

may you write how could i sort it ?

vinieme12 — Sat, 07 May 2022 18:37:29 GMT

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

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

georgeD — Sun, 08 May 2022 06:59:33 GMT

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