8 Replies Latest reply: Jul 5, 2016 2:07 PM by Michael Granillo RSS

    Removal of double counting

    Sarah Bootman

      We have downloaded government contract data into Excel and uploaded to Qlik Sense. It shows contract information. Each row shows information to an update to an existing contract. For example, 5 consecutive rows can show 6 annual updates for 1 contract (see highlighted rows in attached)

       

      Our goal is to count the “Contract Office Name” only once per specific contract “Contract ID”. We want to have a pie graph representing the percentage of each Contracting Office Name but can't figure out how to use the functions to not double count with respect to the contract updates.

       

      Thank you!Screenshot (14).png