This content has been marked as final. Show 2 replies
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.
If this is in the sql database:
Then I would need qlikview to return this count for me for looking for 'search' by customer by yesterdays date.
Thank you for your help!