Requesting help with Aggregation Value to repeat

[Mirza_Faran]

Hi Experts,

I am new to QlikView and I need your help. I am looking to see how I can repeat my aggregated expression value for each row regardless of association. I see the aggregated value does not repeat for all the rows as shown image. Any help would be greatly appreciated. The desired state is to see 496 repeat itself for all rows from the below example.

Original StateState with FormulaRequested State

Thanks,

Mirza

[rwunderlich]

Aggr() has a DISTINCT/NODISTINCT keyword for which the default is DISTINCT.  You will need to add the NODISTINCT keyword. 

Sum(Aggr(NODISTINCT Sum(DISTINCT Value), ABC))

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/aggr.htm

By the way, TOTAL in the Sum() may be a better solution to this.  You would not need Aggr()

Sum(TOTAL Value)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Mirza_Faran]

Thanks Rob, will try the solution. 

[Mirza_Faran]

Thanks Rob, that worked.