8 Replies Latest reply: Oct 27, 2017 5:04 PM by Justin Cotto RSS

    Counting occurrences in a bar chart.

    Justin Cotto

      Hello,

       

      I have a chart that records employee information.  There is a column labeled Record_Type that labels each employee as HIRE, TERM, TRANSFER or HEADCOUNT.  I want to make a table and chart that displays the number of Hires and Terminations by Business Unit.  I am brand new to Qlik and was wondering what statement I could use to count hires and terminations while excluding the others.  Initially I thought to use GetSelectedCount but I am not sure how to approach this problem.


      Thank you