Qlikview Aggr() Help

[Anonymous]

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

[sunny_talwar · Accepted solution]

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]))

[Anonymous]

Hi Sunny,

Thanks for your help. Its worked.

Regards

Sujay