Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to group the data

Kindy help me how to group some data became to one in one column. example 

field 1 have same data and field 2 have different and wanna group field 1 for represent field 2

 

state[field 1]ptt [field 2]
JOHORSEGAMAT
JOHORMUAR
JOHORTANGKAK
JOHORJOHOR BAHRU
JOHORRENGET
KEDAHKUALA MUDA
KEDAHTANJUNG DAWAI
KEDAHSUNGAI PETANI
SELANGORSHAH ALAM
SELANGORAMPANG
SELANGORSELANGOR BARAT
2 Replies
Highlighted
Creator
Creator

please show the desired output.
Highlighted
Contributor III
Contributor III

Try converting into a Pivot table.