Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
maybe with a calculated dimension
=date(monthstart(Date), 'YYYY/MM')
and expression
count(distinct Doc_ID)