2 Replies Latest reply: Sep 4, 2014 1:50 PM by sally Mains RSS

    Getting the count for a day for customers

    sally Mains

      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!