topic Unique No in QlikView

Unique No

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a table as below

Solution required:-

1. The Unique count of employee who have delivered sales is 5... i.e it removes the duplicates and does not consider those employees with NIL values

2. Employee wise average is (Emp 11 is 13 + Emp 12 is 28 + Emp 14 is 12 + Emp 17 is 19 + emp 19 is 16) / 5

This has to be in the form of an expression .

Please assist

Regards

sunny_talwar — Tue, 29 Nov 2016 12:27:20 GMT

May be this:

Avg(Aggr(If(Sum(Target) > 0, Sum(Target)), [Emp ID]))

Gysbert_Wassenaar — Tue, 29 Nov 2016 12:48:33 GMT

1. count({<Target={"<>0"}>}distinct [Emp ID])

2. sum([Target])/count({<Target={"<>0"}>}distinct [Emp ID])