Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Create a Straight Table
Dimension = Customer
Expression
COUNT({<Action = {'search'}, Date = {'$(=Date(Today()-1))'}>}Action)
Create a Straight Table
Dimension = Customer
Expression
COUNT({<Action = {'search'}, Date = {'$(=Date(Today()-1))'}>}Action)
Thanks that worked!