Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
chipmunkG
Contributor
Contributor
‎2018-11-15 03:49 AM

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
610 Views
0 Likes
2 Replies
fallenangel6
Creator
Creator
‎2018-11-15 03:57 AM

please show the desired output.
604 Views
0 Likes
sonkumamon
Creator
Creator
‎2018-11-15 04:05 AM

Try converting into a Pivot table.
600 Views
0 Likes