count with no activity

Tue, 03 Jan 2012 16:15:40 GMT

hi,

for simplisty i have 2 tabels orders and customers. linked by field custid.

order table columns: orderid, custid, orderdate, orderyear, ordernum

customers table columns: custid, create_date, name

the needed oupput is

orderyear	count orders	count customers	count customers with no order

the problem is the last column.

It count all customers created until the orderyear but doesnt have any order in this year.

thanks,

Tue, 03 Jan 2012 20:05:13 GMT

try this for the last column

Count( TOTAL Distinct Custid) - Count( Distinct Custid)

topic count with no activity in QlikView