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