topic Re: with selection correct value without selection constant value in QlikView

with selection correct value without selection constant value

agastya — Fri, 27 Mar 2020 13:44:23 GMT

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)

Re: with selection correct value without selection constant value

agastya — Fri, 27 Mar 2020 14:24:17 GMT

@sunny_talwar

Re: with selection correct value without selection constant value

agastya — Fri, 27 Mar 2020 16:29:10 GMT

anyone guys need your input on this

Re: with selection correct value without selection constant value

Brett_Bleess — Tue, 21 Apr 2020 19:29:24 GMT

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