topic Values not grouping by field in table in QlikView https://community.qlik.com/t5/QlikView/Values-not-grouping-by-field-in-table/m-p/141162#M21023 <HTML><HEAD></HEAD><BODY><P style="margin: 0 0 10.66px;"><SPAN style="margin: 0px; color: #575757; line-height: 107%; font-family: 'Arial',sans-serif; font-size: 10pt;">I have not had this issue amongst other reporting, and I'm not sure if it has to do with the date field having a time stamp before I am reformatting it, but let me know what you think. The data is pretty straight forward, but wont roll up under the same Client or Date field...</SPAN></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/215390_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 08 Oct 2018 16:05:33 GMT MalcolmCICWF 2018-10-08T16:05:33Z Values not grouping by field in table https://community.qlik.com/t5/QlikView/Values-not-grouping-by-field-in-table/m-p/141162#M21023 <HTML><HEAD></HEAD><BODY><P style="margin: 0 0 10.66px;"><SPAN style="margin: 0px; color: #575757; line-height: 107%; font-family: 'Arial',sans-serif; font-size: 10pt;">I have not had this issue amongst other reporting, and I'm not sure if it has to do with the date field having a time stamp before I am reformatting it, but let me know what you think. The data is pretty straight forward, but wont roll up under the same Client or Date field...</SPAN></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/215390_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 08 Oct 2018 16:05:33 GMT https://community.qlik.com/t5/QlikView/Values-not-grouping-by-field-in-table/m-p/141162#M21023 MalcolmCICWF 2018-10-08T16:05:33Z Re: Values not grouping by field in table https://community.qlik.com/t5/QlikView/Values-not-grouping-by-field-in-table/m-p/141163#M21024 <HTML><HEAD></HEAD><BODY><P>Yes, i think its due to reformatting internally that date still holding timestamp. Try using format like Floor() or Num() around your dates creating a new field. </P></BODY></HTML> Mon, 08 Oct 2018 16:09:31 GMT https://community.qlik.com/t5/QlikView/Values-not-grouping-by-field-in-table/m-p/141163#M21024 vishsaggi 2018-10-08T16:09:31Z Re: Values not grouping by field in table https://community.qlik.com/t5/QlikView/Values-not-grouping-by-field-in-table/m-p/141164#M21025 <HTML><HEAD></HEAD><BODY><P>Ok that's the only think I could think of causing the problem. Good suggestions, let me try that and I'll</P><P> report back!</P></BODY></HTML> Mon, 08 Oct 2018 19:18:34 GMT https://community.qlik.com/t5/QlikView/Values-not-grouping-by-field-in-table/m-p/141164#M21025 MalcolmCICWF 2018-10-08T19:18:34Z Re: Values not grouping by field in table https://community.qlik.com/t5/QlikView/Values-not-grouping-by-field-in-table/m-p/141165#M21026 <HTML><HEAD></HEAD><BODY><P>That did work, thanks for the suggestion</P></BODY></HTML> Wed, 10 Oct 2018 13:13:51 GMT https://community.qlik.com/t5/QlikView/Values-not-grouping-by-field-in-table/m-p/141165#M21026 MalcolmCICWF 2018-10-10T13:13:51Z