topic Re: Set Analysis not work in QlikView

Set Analysis not work

Fri, 26 Feb 2016 23:19:50 GMT

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 — Sat, 27 Feb 2016 01:51:59 GMT

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)

Sun, 28 Feb 2016 16:44:47 GMT

Peter,Your formula works.
Thank you very very much

Chanty4u — Tue, 01 Mar 2016 06:56:41 GMT

Hi,

Please close the thread if u got the solution

chk below link

Tue, 01 Mar 2016 11:17:51 GMT

Peter,

can you write a correct formula for the total?

please