Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ahsanshahzad
Contributor II

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
Honored Contributor III

Re: How to count number of transactions in table

PFA,

5 Replies
shraddha_g
Honored Contributor III

Re: How to count number of transactions in table

PFA,

agigliotti
Honored Contributor II

Re: How to count number of transactions in table

maybe this:

for InvoiceCount = Count( InvoiceId )

for TotalAmount = Sum( Amount )

mdmukramali
Valued Contributor II

Re: How to count number of transactions in table

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


ahsanshahzad
Contributor II

Re: How to count number of transactions in table

Thank You

This shows what I exactly needed

ahsanshahzad
Contributor II

Re: How to count number of transactions in table

Thank You Mohammed