Total Aggr Expression for Each Row

byrnel0586 — Wed, 17 Oct 2018 17:06:28 GMT

Hi all,

I currently have a straight table that displays an overall weighted avg at the bottom due to total mode being enabled. I need to modify the expression so that that overall weighted avg (3.00) shows on each row, not just the last one as a total.

Below is the expression I'm currently using and a screenshot of the table:

=if(num(ReportDate) < '43312',
SUM(Aggr(
IF($(RoundedRate%)>=num#(PtileBeg) and $(RoundedRate%)<= num#(PtileEnd)
,Star) * Only(RptCardWeight)
,Star,_MeasureYearKey,PCP_ID))
/
SUM( RptCardWeight),
round(SUM(Aggr(
IF($(RoundedRate%)>=num#(PtileBeg) and $(RoundedRate%)<= num#(PtileEnd)
,Star) * Only(RptCardWeight)
,Star,_MeasureYearKey,PCP_ID))
/
SUM( RptCardWeight) ,0.1))

Any help is much appreciated!!

Re: Total Aggr Expression for Each Row

byrnel0586 — Wed, 17 Oct 2018 17:08:53 GMT

Never mind I think I just got it

=round(SUM(TOTAL(Aggr(
IF($(RoundedRate%)>=num#(PtileBeg) and $(RoundedRate%)<= num#(PtileEnd)
,Star) * Only(RptCardWeight)
,Star,_MeasureYearKey,PCP_ID)))
/
SUM( TOTAL(RptCardWeight)) ,0.1)

topic Total Aggr Expression for Each Row in QlikView

Total Aggr Expression for Each Row

Re: Total Aggr Expression for Each Row