5 Replies Latest reply: Dec 11, 2012 10:40 AM by Colleen Dauphin RSS

    adding Totals

      I have been successful putting all my data into a qlikview, I am needing to total something a particular list box.  I have a qlikview with customers, orders and drivers that ran  those orders. All drivers have multiple orders, and the total is adding up how many times all the drivers show up, I am just wanting to know how many drivers there were not the times they show up. I have created a statistics box already.  What is the proper way to just get the number of drivers? Total count gives me how many total orders, i am needing total driver that worked that month.

      For example: Driver 1   25 orders

                           Driver 2    55 orders

       

      I just want it to add up =2 drivers, not 80 drivers