topic Requesting help with Aggregation Value to repeat in QlikView

Requesting help with Aggregation Value to repeat

Mirza_Faran — Thu, 05 May 2022 21:23:42 GMT

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

Re: Requesting help with Aggregation Value to repeat

rwunderlich — Thu, 05 May 2022 22:46:43 GMT

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

Re: Requesting help with Aggregation Value to repeat

Mirza_Faran — Thu, 05 May 2022 23:40:10 GMT

Thanks Rob, will try the solution.

Re: Requesting help with Aggregation Value to repeat

Mirza_Faran — Fri, 13 May 2022 18:55:29 GMT

Thanks Rob, that worked.