with selection correct value without selection constant value

[agastya]

with year selection getting corerct  GRAND Average output i.e

2020  :83%

2019:83%

2018:83%

2017:82%

2016:82%

Without any selection its showing like this

2020  :83%

2019:83%

2018:83%

2017:83%

2016:83%

Dimension:Year

=Round(avg( {1}TOTAL (aggr(((COUNT({<Created_Year=,Created_Month=,Created_Quarter=,kht -={' '},DATE={"<=$(=max(DATE))"}>}

Aggr(IF(COUNT({<Created_Year=,Created_Month=,Created_Quarter=,kht -={' '},DATE={"<=$(=max(DATE))"}>}Distinct Key)=1, 1)

,kht ,Project)))
/

Count({<Created_Year=,Created_Month=,Created_Quarter=,kht -={' '},DATE={"<=$(=max(DATE))"}>}DISTINCT kht )),Project))),0.01)

[agastya]

@sunny_talwar 

[agastya]

 anyone guys  need your input on this 

[Brett_Bleess]

Would likely be most helpful for you to attach sample QVW file so folks can see everything.  In lieu of that, the best I have is the following Design Blog post that may be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

If you want to do some further searching in that area, here is the link to do so:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett