Grouping Dates & Totalling

[JThomas86]

Hello, 

I'm fairly new to QLIK and have no script or coding background.

I have a data set that shows decisions made on individual days - e.g. 01/01/2018, 02,03/2019, etc.  I need to group these dates, and total the frequency count for each month.  

I've used the below to group the dates:

=Date([ field name i'm using],'MMMYYYY'), and that has worked, but I'm yet to work out how to total the frequency of decisions made each month.  I'd like to have a graph that shows how many decisions were made in each month.

Sorry if i'm missing something obvious here. 

The graph i'm trying to breakdown:

[sidhiq91]

@JThomas86  You need to use Month Field that you created as your Dimension.

Measure: Count([Descisions Made]).

Also, the best option here would be to create a Master Calendar.

If this resolves your issue, please like and accept it as a solution.

[JThomas86]

Thank you for the reply Sidhiq.

I'm still getting an issue:

I need the above figures to be grouped by month, rather than show as individual lines of data.   

Hoping that makes sense.

[sidhiq91]

@JThomas86  Please use the below link to understand how to create a master calendar:

https://community.qlik.com/t5/QlikView-App-Dev/How-to-Create-Master-Calendar/td-p/103109

Once you create it and still facing an issue. Please let us know.