Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

starheartbeam
Contributor

Getting the count for a day for customers

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:

CustDateAction
01239/3/2014search
98769/3/2014search
01239/3/2014order
01239/3/2014search
98769/1/2014order
01239/3/2014order

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

CustomerCount
01232
98761

Thank you for your help!

1 Solution

Accepted Solutions

Re: Getting the count for a day for customers

Create a Straight Table

Dimension = Customer

Expression

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

2 Replies

Re: Getting the count for a day for customers

Create a Straight Table

Dimension = Customer

Expression

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

starheartbeam
Contributor

Re: Getting the count for a day for customers

Thanks that worked!