topic Qlikview Aggr() Help in QlikView

Qlikview Aggr() Help

Anonymous — Fri, 10 Mar 2017 09:58:25 GMT

Hi All,

I need to calculate 7 columns in the Front End, (not in the script). Out of 7 calculated columns, I have calculated 6 columns, but not able to create the 7th column (Load Margin $). (Each columns uses the previously calculated column).

I need your help in calculating the 7th column. Sample Data and Formula for each column are in the attached QVW files.

Regards

Sujay

Re: Qlikview Aggr() Help

sunny_talwar — Fri, 10 Mar 2017 12:28:04 GMT

I am getting this

Using this

Sum(TOTAL <[Load ID]> Aggr(

((((([Shipment Space]/[Total Load Space])*[Total Load Cost])/Sum(Distinct TOTAL <[PO Number]> ([Shipment Space]/[Total Load Space])*[Total Load Cost]))*[Shipment Charged Amt])-(([Shipment Space]/[Total Load Space])*[Total Load Cost]))

,[Load ID], [PO Number]))

Re: Qlikview Aggr() Help

Anonymous — Fri, 10 Mar 2017 16:58:58 GMT

Hi Sunny,

Thanks for your help. Its worked.

Regards

Sujay