16 Replies Latest reply: Jun 10, 2016 5:42 PM by Stefan Wühl RSS

    Counting Created Customer Per Month

    Omotayo Olokede

      Good Afternoon,

           pls i am new to Qlikview and i have some reports running very well, but my boss requested for a reprot that will display the total number of created customers per month based on branch.

      i have a field in my table that holds Customer Created Date = CUST_CREATE_DATE

      I tried but all i am getting is an empty table.

       

      I have Branch name and Month as my Dimensions and my Expression goes below;

      if(CUST_CREATED_DATE = today(), count(CUST_ID))

       

      I want the report to be on a pivot table having BRANCH NAME on my left, Month at the TOP and the Counts under each Month and Branch respectively.

       

      Any help Please.