Count records per month, and place months on Line Graph

[kgeen]

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!

[Saravanan_Desingh]

Try like this.

Count(MonthStart(FIELD))

[Kushal_Chawda · Accepted solution]

Create a graph 

Dimension:

monthname(FIELD)

Expression:

Count(FIELD)

[kgeen]

Thank you, this is what I needed. I was able to model the data how I was expecting it to display.