2 Replies Latest reply: Oct 4, 2018 4:39 PM by Stefan Wühl RSS

    Sum all values - including duplicates

    Sophie Grant

      Hi all,

       

      I want to sum all of my values in the variable 'Weighting Factor',

      Qlik is removing duplicate values as default, even though I want to sum everything.

      I end up with a sum of all of the unique weighting factors by default.

       

      Is there a way to do "sum ([Weighting Factor])" but add something that would force Qlik to include everything?

       

      Thanks