Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Qlikview Aggr() Help

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
Highlighted

Re: Qlikview Aggr() Help

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

Contributor
Contributor

Re: Qlikview Aggr() Help

Hi Sunny,

Thanks for your help. Its worked.

Regards

Sujay