4 Replies Latest reply: Feb 21, 2018 3:42 PM by Alexander James Tomlins RSS

    Expression Help! Percentage of subtotal against Total

    Alexander James Tomlins

      HI Guys,

       

      I've always struggled on how to get a percentage of something that is already split as a dimension  in Qlik Sense.

       

      for example i have cs contacts split by different merchants as my dimension but would like to see the Percentage of the merchant split contacts out of the total contacts. So far i have;

       

      Count(CSContacts) / Count({<[MerchantName]=>}CSContacts)

       

      I very much feel like i am miles off here and that the answer is really simple. I'm sure someone has asked this but i couldn't find it.

       

      Please help

       

      Thanks,

       

      Alex