Skip to main content
Announcements
Meet the 2024 Qlik Luminaries and Partner Ambassadors! READ ON!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlikview Aggr() Help

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

1 Solution

Accepted Solutions
sunny_talwar

I am getting this

Capture.PNG

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

View solution in original post

2 Replies
sunny_talwar

I am getting this

Capture.PNG

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
Not applicable
Author

Hi Sunny,

Thanks for your help. Its worked.

Regards

Sujay