Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lucascmrosa
New Contributor

Count the amount per Month of the Year

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?

2 Replies
satishkurra
Valued Contributor II

Re: Count the amount per Month of the Year

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

MVP
MVP

Re: Count the amount per Month of the Year

maybe with a calculated dimension

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

and expression

count(distinct Doc_ID)

Community Browser