Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

May be try this

Dimensions

Dept
PO ID
invoiceID

Expression

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

View solution in original post

Contributor III
Contributor III

Please  find the macro file