topic Re: Using AVG in set Analysis in QlikView

Using AVG in set Analysis

sutoniusahadong — Thu, 21 Mar 2019 11:04:55 GMT

Dear All,

Can help me, is it possible to run this script

=COUNT(DISTINCT {<Avg(BOBOT)={">3.05"}>} EMP_NO)

What alternative i can use ?

Re: Using AVG in set Analysis

HirisH_V7 — Thu, 21 Mar 2019 11:31:12 GMT

You can use if condition like,
If(Avg(BOBOT)>'3.05',
COUNT(DISTINCT EMP_NO)

i don't think set-analysis will work such way, will check anyway. You can do this avg in script and create a column. you can use the same in set analysis directly.

Re: Using AVG in set Analysis

sunny_talwar — Thu, 21 Mar 2019 12:34:14 GMT

Try this instead

=Count(DISTINCT {<EMP_NO = {"=Avg(BOBOT) > 3.05"}>} EMP_NO)

Re: Using AVG in set Analysis

HirisH_V7 — Thu, 21 Mar 2019 12:40:22 GMT

Cool 🙂 it working bro. @sutoniusahadong you can use this & close thread.