6 Replies Latest reply: Aug 12, 2014 4:55 PM by Sean Donovan RSS

    How to count unique values ?

      Hi All,

       

      I am new to QlikSense. I need to calculate the unique count of variables in a table/column. For e.g.

       

      Exit TypeMonthLocation
      VoluntaryJanuaryPune
      InvoluntaryJanuaryPune
      VoluntaryFebruary

      Bangalore

       

      Now I need to calculate = (Total number of Volunatry cases)/(Total number of Volunatry cases+Total number of Involunatry cases)

       

       

      Thanks

      Anurag Gupta