Set Analysis not work

[#1]

I want calculate an index DP%.

numerator =
Total customers  turnover  supplied by the wholesaler who bought an article.

Denominator
total turnover of the wholesaler

Example

Numerator = 30565

Denominator=1927067

DP=1.5%

if I select one item, my formula is correct

if I don’t select one item,it not work.

can you help me
thank you

[Peter_Cammaert]

The %DP calculation is a bit weird (disable the Total, because it will produce garbage), but you can try with this expression:

=sum(aggr(sum({<COD_ARTICOLO=>} TOTAL <COD_FILIALE,COD_ESERCIZIO> FATTURATO), COD_FILIALE, COD_ARTICOLO, COD_ESERCIZIO)) /

aggr(sum({<COD_ARTICOLO=, COD_ESERCIZIO=>} TOTAL <COD_FILIALE> FATTURATO), COD_FILIALE, COD_ARTICOLO, COD_ESERCIZIO)

[#3]

Peter,Your formula works.
Thank you very very much

[Chanty4u]

Hi,

Please close the thread if u got the solution

chk below link

Qlik Community Tip: Marking Replies as Correct or Helpful

[#5]

Peter,

can  you  write a correct formula for the total?

please