topic Re: My Data for my chart is not grouping in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/My-Data-for-my-chart-is-not-grouping/m-p/668191#M363 <HTML><HEAD></HEAD><BODY><P>Thank you so much.....it works perfectly</P></BODY></HTML> Wed, 13 Aug 2014 13:40:21 GMT 2014-08-13T13:40:21Z My Data for my chart is not grouping https://community.qlik.com/t5/Qlik-Learning-Discussions/My-Data-for-my-chart-is-not-grouping/m-p/668188#M360 <HTML><HEAD></HEAD><BODY><P>I am new to QlikView, and I'm having a problem grouping my data.&nbsp; I would appreciate anybody who can assist me.&nbsp; I'm trying to group my data by month/year...and to drill into each individual day.&nbsp;&nbsp; I load the data as follows...</P><P></P><P>Load</P><P>"Shift_date",</P><P>date(Shift_date,'YYYY-MM' ) as yrMonth,</P><P>..........</P><P></P><P>I add an new Chart and add the new group by Properties -&gt; Dimensions -&gt; Edit Group -&gt; New .....and add Fields "yrMonth" and "Shift_date" as a Drill-down Group.</P><P>&nbsp;&nbsp; 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.&nbsp;&nbsp; Instead it displays all days for both months.....Again, any help will be much appreciated. ...Thanks in advance</P></BODY></HTML> Tue, 12 Aug 2014 19:54:17 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/My-Data-for-my-chart-is-not-grouping/m-p/668188#M360 2014-08-12T19:54:17Z Re: My Data for my chart is not grouping https://community.qlik.com/t5/Qlik-Learning-Discussions/My-Data-for-my-chart-is-not-grouping/m-p/668189#M361 <HTML><HEAD></HEAD><BODY><P>Hi Gary,</P><P></P><P>Can you attach a sample? May be simpler/faster way to resolve issue.</P><P></P><P>Best,</P><P></P><P>Matt</P></BODY></HTML> Tue, 12 Aug 2014 20:34:42 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/My-Data-for-my-chart-is-not-grouping/m-p/668189#M361 2014-08-12T20:34:42Z Re: My Data for my chart is not grouping https://community.qlik.com/t5/Qlik-Learning-Discussions/My-Data-for-my-chart-is-not-grouping/m-p/668190#M362 <HTML><HEAD></HEAD><BODY><P>You will need to use monthstart() to force all dates to the beginning of then month in addition to formatting the date.</P></BODY></HTML> Tue, 12 Aug 2014 22:40:30 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/My-Data-for-my-chart-is-not-grouping/m-p/668190#M362 Jennifer_Moore 2014-08-12T22:40:30Z Re: My Data for my chart is not grouping https://community.qlik.com/t5/Qlik-Learning-Discussions/My-Data-for-my-chart-is-not-grouping/m-p/668191#M363 <HTML><HEAD></HEAD><BODY><P>Thank you so much.....it works perfectly</P></BODY></HTML> Wed, 13 Aug 2014 13:40:21 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/My-Data-for-my-chart-is-not-grouping/m-p/668191#M363 2014-08-13T13:40:21Z Re: My Data for my chart is not grouping https://community.qlik.com/t5/Qlik-Learning-Discussions/My-Data-for-my-chart-is-not-grouping/m-p/668192#M364 <HTML><HEAD></HEAD><BODY><P>Matthew....thanks for you response too, but I wasn't sure what and how to attach</P></BODY></HTML> Wed, 13 Aug 2014 13:41:02 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/My-Data-for-my-chart-is-not-grouping/m-p/668192#M364 2014-08-13T13:41:02Z