Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Set Analysis not work

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

4 Replies

Re: Set Analysis not work

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)

Not applicable

Re: Set Analysis not work

Peter,Your formula works.
Thank you very very much

Chanty4u
Esteemed Contributor III

Re: Set Analysis not work

Hi,

Please close the thread if u got the solution

chk below link

Qlik Community Tip: Marking Replies as Correct or Helpful

Not applicable

Re: Set Analysis not work

Peter,

can  you  write a correct formula for the total?

please

Community Browser