Discussion board where members can get started with Qlik Sense.
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
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
maybe with a calculated dimension