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: 
Shahzad_Ahsan
Creator III
Creator III

How to count number of transactions in table

Hello Everyone

I have two tables; Customer & Invoice

Customer table has 1000 records like this

CustomerIdCustomerName
1A
2B
3C
4D
5E

Invoice Table contains 100 records like this

InvoiceIdCustomerIdAmount
111000
23500
35600
41200
51100
63600

I want all 100 records from Invoice table like this

CustomerIdCustomerNameInvoiceCountTotalAmount
1A31300
3C21100
5E1600
1 Solution

Accepted Solutions
shraddha_g
Partner - Master III
Partner - Master III

5 Replies
shraddha_g
Partner - Master III
Partner - Master III

PFA,

agigliotti
Partner - Champion
Partner - Champion

maybe this:

for InvoiceCount = Count( InvoiceId )

for TotalAmount = Sum( Amount )

mdmukramali
Specialist III
Specialist III

Hi,

Customer & Invoice both are connected by CustomerId.


Then use the straight table :


Dimension : CustomerId ,CustomerName


Expression : Count(InvoiceId)   //Count(Distinct InvoiceId)


Expression : Sum(Amount)


Thanks,

Mukram


Shahzad_Ahsan
Creator III
Creator III
Author

Thank You

This shows what I exactly needed

Shahzad_Ahsan
Creator III
Creator III
Author

Thank You Mohammed