Account by average result

cinthya-er — Mon, 22 May 2017 22:41:42 GMT

Hello,

I am facing a nesting problem, I have an application where I need to get the project account given the percentage obtained from an average of their interviewees, each project has a one-to-many relationship and the project count will depend on the average of each Project (From interviews).

I leave the example:

This is a graph with the Projects dimension

To get the account of projects by color is necessary to get the average rating by average and depending on the range make an account and get by rank the percentage.

=COUNT(DISTINCT {<Aggr(Avg([Rating]),Proyect)={">=0.9"}>}[Proyecto)

My formula is not working.

I hope you have already faced something similar and can help me to solve this small setback.

Regards!!

Cin ER

Re: Account by average result

sunny_talwar — Tue, 23 May 2017 16:20:23 GMT

May be this

=Count(DISTINCT {<Proyecto = {"=Avg([Rating]) >= 0.9"}>} Proyecto)

Re: Account by average result

cinthya-er — Tue, 23 May 2017 16:53:11 GMT

Thank you very much, I did not know that it could be evaluated within a set analysis, you saved my life

topic Re: Account by average result in QlikView

Account by average result

Re: Account by average result

Re: Account by average result