2 Replies Latest reply: Sep 18, 2015 9:26 AM by Massimo Grossi RSS

    Count the amount per Month of the Year

    lucas rosa

      Hello guys, I'm new at Qlik and I'm trying to learn by using the sense desktop utility.

       

      I have a database with a date column that looks like this:
      *DD/MM/YYYY

      DateDoc_ID
      10/08/20141
      02/08/20142
      03/02/20153
      04/02/20154
      07/02/20155
      10/03/20156
      11/03/20157
      02/04/20158

       

      I want to make a line graph with the amount of Doc's per month of the year, like:
      2 Docs on 08/2014

      3 Docs on 02/2015

      2 Docs on 03/2015

      1 Doc on   04/2015

       

      How can i do this with set analysis?