Getting the count for a day for customers

[Anonymous]

I have been trying to figure this out and cant see to get it to work for me.

I have a list of customers "Cust" , a list of dates "date" and a row called "action" that ether has 'order' or 'search' in it.

I need to find the count that 'search' is in the "action" row for a customer "cust" for yesterdays date.  I am not sure how I would go about doing this.  Please help I have been working on this for two days and cant seem to get it to work out for me.  I hope I explained what I am trying to do.

Example:

If this is in the sql database:

Cust	Date	Action
0123	9/3/2014	search
9876	9/3/2014	search
0123	9/3/2014	order
0123	9/3/2014	search
9876	9/1/2014	order
0123	9/3/2014	order

Then I would need qlikview to return this count for me for looking for 'search' by customer by yesterdays date.

Customer	Count
0123	2
9876	1

Thank you for your help!

[MK_QSL · Accepted solution]

Create a Straight Table

Dimension = Customer

Expression

COUNT({<Action = {'search'}, Date = {'$(=Date(Today()-1))'}>}Action)

[Anonymous]

Thanks that worked!