topic How to group the data in Water Cooler https://community.qlik.com/t5/Water-Cooler/How-to-group-the-data/m-p/1506932#M5180 <P>Kindy help me how to group some data became to one in one column. example&nbsp;</P><P>field 1 have same data and field 2 have different and wanna group field 1 for represent field 2</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>state[field 1]</TD><TD>ptt [field 2]</TD></TR><TR><TD>JOHOR</TD><TD>SEGAMAT</TD></TR><TR><TD>JOHOR</TD><TD>MUAR</TD></TR><TR><TD>JOHOR</TD><TD>TANGKAK</TD></TR><TR><TD>JOHOR</TD><TD>JOHOR BAHRU</TD></TR><TR><TD>JOHOR</TD><TD>RENGET</TD></TR><TR><TD>KEDAH</TD><TD>KUALA MUDA</TD></TR><TR><TD>KEDAH</TD><TD>TANJUNG DAWAI</TD></TR><TR><TD>KEDAH</TD><TD>SUNGAI PETANI</TD></TR><TR><TD>SELANGOR</TD><TD>SHAH ALAM</TD></TR><TR><TD>SELANGOR</TD><TD>AMPANG</TD></TR><TR><TD>SELANGOR</TD><TD>SELANGOR BARAT</TD></TR></TBODY></TABLE> Thu, 15 Nov 2018 08:49:42 GMT chipmunkG 2018-11-15T08:49:42Z How to group the data https://community.qlik.com/t5/Water-Cooler/How-to-group-the-data/m-p/1506932#M5180 <P>Kindy help me how to group some data became to one in one column. example&nbsp;</P><P>field 1 have same data and field 2 have different and wanna group field 1 for represent field 2</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>state[field 1]</TD><TD>ptt [field 2]</TD></TR><TR><TD>JOHOR</TD><TD>SEGAMAT</TD></TR><TR><TD>JOHOR</TD><TD>MUAR</TD></TR><TR><TD>JOHOR</TD><TD>TANGKAK</TD></TR><TR><TD>JOHOR</TD><TD>JOHOR BAHRU</TD></TR><TR><TD>JOHOR</TD><TD>RENGET</TD></TR><TR><TD>KEDAH</TD><TD>KUALA MUDA</TD></TR><TR><TD>KEDAH</TD><TD>TANJUNG DAWAI</TD></TR><TR><TD>KEDAH</TD><TD>SUNGAI PETANI</TD></TR><TR><TD>SELANGOR</TD><TD>SHAH ALAM</TD></TR><TR><TD>SELANGOR</TD><TD>AMPANG</TD></TR><TR><TD>SELANGOR</TD><TD>SELANGOR BARAT</TD></TR></TBODY></TABLE> Thu, 15 Nov 2018 08:49:42 GMT https://community.qlik.com/t5/Water-Cooler/How-to-group-the-data/m-p/1506932#M5180 chipmunkG 2018-11-15T08:49:42Z Re: How to group the data https://community.qlik.com/t5/Water-Cooler/How-to-group-the-data/m-p/1506938#M5184 please show the desired output. Thu, 15 Nov 2018 08:57:20 GMT https://community.qlik.com/t5/Water-Cooler/How-to-group-the-data/m-p/1506938#M5184 fallenangel6 2018-11-15T08:57:20Z Re: How to group the data https://community.qlik.com/t5/Water-Cooler/How-to-group-the-data/m-p/1506942#M5186 Try converting into a Pivot table. Thu, 15 Nov 2018 09:05:35 GMT https://community.qlik.com/t5/Water-Cooler/How-to-group-the-data/m-p/1506942#M5186 sonkumamon 2018-11-15T09:05:35Z