My Data for my chart is not grouping

[#1]

I am new to QlikView, and I'm having a problem grouping my data.  I would appreciate anybody who can assist me.  I'm trying to group my data by month/year...and to drill into each individual day.   I load the data as follows...

Load

"Shift_date",

date(Shift_date,'YYYY-MM' ) as yrMonth,

..........

I add an new Chart and add the new group by Properties -> Dimensions -> Edit Group -> New .....and add Fields "yrMonth" and "Shift_date" as a Drill-down Group.

   When selecting all days for 2 months...say June and July...I expect to see 2 Bar charts for June and July and to drill into a bar (say June) and to view all individual days.   Instead it displays all days for both months.....Again, any help will be much appreciated. ...Thanks in advance

[#2]

Hi Gary,

Can you attach a sample? May be simpler/faster way to resolve issue.

Best,

Matt

[Jennifer_Moore · Accepted solution]

You will need to use monthstart() to force all dates to the beginning of then month in addition to formatting the date.

[#4]

Thank you so much.....it works perfectly

[#5]

Matthew....thanks for you response too, but I wasn't sure what and how to attach