3 Replies Latest reply: Mar 13, 2018 7:35 PM by Yuji Yamane RSS

    Grouping Dates by Month

    Lea Cueva

      What is the expression to group dates by month?


      I have a data set with dates that I uploaded via a spreadsheet.  I created a bar chart with Qlik, but I need the individual dates to be grouped by month.  


      For example, I need 12/01/2017 through 12/31/2017 showing as Dec 2017, 01/01/2018 through 01/31/2018 showing as Jan 2018, and so on.


      I'm an expression newbie so please explain in very simple terms.


      Thank you so much!