topic List box in QlikView

List box

NavinReddy — Tue, 22 Apr 2014 12:03:50 GMT

Dear All,

i am calculating AVG for Using this Expression

=sum(pay_amount)/count(distinct standard id])

in list box i have three business how can i write separate expression each one

BusinessUnit1-----i want to show each business AVG separate

Business Unit2---Where can i apply this business Filter in Expression

Business Unit3---

Thanks In Advance

Niranjan

alexandros17 — Tue, 22 Apr 2014 12:06:50 GMT

Something like:

sum(Aggr(pay_amount,Business1))/count(Aggr(distinct standard id], Business1))

its_anandrjs — Tue, 22 Apr 2014 12:08:09 GMT

Write like

1. =sum ({<YourListBoxfield = {' BusinessUnit1 '}>} pay_amount)/count(distinct {<YourListBoxfield = {' BusinessUnit1 '}>} standard id])

2. =sum ({<YourListBoxfield = {' BusinessUnit2 '}>} pay_amount)/count(distinct {<YourListBoxfield = {' BusinessUnit2 '}>} standard id])

3. =sum ({<YourListBoxfield = {' BusinessUnit3 '}>} pay_amount)/count(distinct {<YourListBoxfield = {' BusinessUnit3 '}>} standard id])