Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fallenangel6
Creator
Creator

Aggregation help

 

Hi,

I have below two tables.

Invoice Table:

DeptPO IDinvoiceIDinvoiceamt
SalesA1IN15000
OfficeA2IN22000
HRA3IN31500

 

invoice Expense table:

invoiceID%distribution
IN120
IN110
IN130
IN110
IN2100
IN3100

 

i want to display the below detail

 

DeptPO IDinvoiceIDinvoiceamtinvoiceamt modified
SalesA1IN150003500
OfficeA2IN220002000
HRA3IN315001500

 

where i used (0.01* percentage distribution * invoiceamount) for each entry of the invoice ID in expense table to get the final modified amount.

how can i get the desired output.

1 Solution

Accepted Solutions
sunny_talwar

May be try this

Dimensions

Dept
PO ID
invoiceID

Expression

Sum(invoiceamt)
Sum(invoiceamt) * Sum(%distribution) * 0.01

View solution in original post

2 Replies
sunny_talwar

May be try this

Dimensions

Dept
PO ID
invoiceID

Expression

Sum(invoiceamt)
Sum(invoiceamt) * Sum(%distribution) * 0.01
xavieravinson
Contributor III
Contributor III

Please  find the macro file