18 Replies Latest reply: Mar 13, 2017 1:07 PM by Silvia Ganhao RSS

    Count the total records of one of the fields of the current selection in Qlik Sense

    Luis Rodriguez

      Good day,


      I was wondering if there is any Set Analisys statement or an example to apply it to my case.


      I want to make an indicator of the Total Sold Product (PV) by Region (REG) of the current selection among the total of Sold Products of the Region to which it belongs.

      The formula should look something like this:


      Indicator = (PV of the current selection) / (PV of the total of the Region to which it belongs)


      * PV = Products Sold



      I would greatly appreciate your help, as I have no idea how to do it.