Count the amount per Month of the Year

[Anonymous]

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

Date	Doc_ID
10/08/2014	1
02/08/2014	2
03/02/2015	3
04/02/2015	4
07/02/2015	5
10/03/2015	6
11/03/2015	7
02/04/2015	8

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?

[satishkurra]

From scripting window first extract Month

Then create a chart with Month as Dimension and Count(Doc_ID) as expression, you will get a monthly breakup

For SET ANALYSIS

Write expression as below

Count({$<Month='Jan'>}Doc_ID).........

Thanks

Satish

[maxgro]

maybe with a calculated dimension

=date(monthstart(Date), 'YYYY/MM')

and expression

count(distinct Doc_ID)