2 Replies Latest reply: May 14, 2017 3:18 AM by Pritam Basak RSS

    Сount number by years

    Sofia Surgucheva

      Hello! I'm new to Qlik and need some help.
      I have three attributes: crossroad_id, value and year.

      Crossroad_IDValue
      Year
      11002015
      12002015
      13002016
      14002016
      21002015
      25002015
      23002015


      I need to count number of crossroads by years.
      For example, final results should look like: 2 crossroads in 2015, 1 crossroad in 2016.

       

      P.S. I need this to build a Bar Chart.