
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count records per month, and place months on Line Graph
Hi Everyone,
I'm new to Qlik Sense, but have been able to figure out a lot of things through the forums, so thank you everyone for your help!
I'm looking to create a line graph that counts the number of records in a given month, but doing this month after month. Each month would then be a point on the graph. For example, the data points would be:
Jan:13
Feb:14
Mar:11
Apr:18
May:10
I would be extracting the dates from a time stamp so looking to capture YYYY-MM from a YYYY-MM-DD HH:MM:SS time stamp.
I've tried using Count(Date(left(FIELD,10),'YYYY/MM')) but that returns daily values, If I decrease the 10 to 7 (in both the dimension and measure, no values show.
Any help that could be provided would be appreciated.
Thank you!
- Tags:
- count
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like this.
Count(MonthStart(FIELD))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create a graph
Dimension:
monthname(FIELD)
Expression:
Count(FIELD)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you, this is what I needed. I was able to model the data how I was expecting it to display.
