I have a views for listing the fields of user profile(profile2), also I have setup a "user flag" . the views has relationship of "(User) Flags:" , the user profile is duplicated in views whenever there are more than 1 flag for this user, I had the same problem with the 8.x version before, it was solved by turn the aggregation on, but this time doesn't work on 7.x. below is my exported views, please advise. thank you

$view = new view();

$view->name = 'business_profile';

$view->description = '';

$view->tag = 'default';

$view->base_table = 'profile';

$view->human_name = 'business profile';

$view->core = 7;

$view->api_version = '3.0';

$view->disabled = FALSE; / Edit this to true to make a default view disabled initially /

/ Display: Master /

$handler = $view->new_display('default', 'Master', 'default');

$handler->display->display_options['use_more_always'] = FALSE;

$handler->display->display_options['access']['type'] = 'none';

$handler->display->display_options['cache']['type'] = 'none';

$handler->display->display_options['query']['type'] = 'views_query';

$handler->display->display_options['exposed_form']['type'] = 'basic';

$handler->display->display_options['pager']['type'] = 'none';

$handler->display->display_options['pager']['options']['offset'] = '0';

$handler->display->display_options['style_plugin'] = 'default';

$handler->display->display_options['row_plugin'] = 'fields';

$handler->display->display_options['row_options']['inline'] = array(

'field_city_biz_profile' => 'field_city_biz_profile',

'field_us_state' => 'field_us_state',

'field_my_country' => 'field_my_country',

'count' => 'count',

'ops' => 'ops',

);

$handler->display->display_options['row_options']['separator'] = ',';

/ Relationship: Profile: User uid /

$handler->display->display_options['relationships']['user']['id'] = 'user';

$handler->display->display_options['relationships']['user']['table'] = 'profile';

$handler->display->display_options['relationships']['user']['field'] = 'user';

/ Relationship: Flags: user_like /

$handler->display->display_options['relationships']['flag_content_rel']['id'] = 'flag_content_rel';

$handler->display->display_options['relationships']['flag_content_rel']['table'] = 'users';

$handler->display->display_options['relationships']['flag_content_rel']['field'] = 'flag_content_rel';

$handler->display->display_options['relationships']['flag_content_rel']['relationship'] = 'user';

$handler->display->display_options['relationships']['flag_content_rel']['required'] = 0;

$handler->display->display_options['relationships']['flag_content_rel']['flag'] = 'user_like';

$handler->display->display_options['relationships']['flag_content_rel']['user_scope'] = 'any';

/ Field: Profile: Avatar /

$handler->display->display_options['fields']['field_user_avatar']['id'] = 'field_user_avatar';

$handler->display->display_options['fields']['field_user_avatar']['table'] = 'field_data_field_user_avatar';

$handler->display->display_options['fields']['field_user_avatar']['field'] = 'field_user_avatar';

$handler->display->display_options['fields']['field_user_avatar']['label'] = '';

$handler->display->display_options['fields']['field_user_avatar']['element_class'] = 'profilelogobackground';

$handler->display->display_options['fields']['field_user_avatar']['element_label_colon'] = FALSE;

$handler->display->display_options['fields']['field_user_avatar']['click_sort_column'] = 'fid';

$handler->display->display_options['fields']['field_user_avatar']['settings'] = array(

'image_style' => 'profile_200x200',

'image_link' => '',

);

/ Field: Profile: Name /

$handler->display->display_options['fields']['field_business_name_1']['id'] = 'field_business_name_1';

$handler->display->display_options['fields']['field_business_name_1']['table'] = 'field_data_field_business_name';

$handler->display->display_options['fields']['field_business_name_1']['field'] = 'field_business_name';

$handler->display->display_options['fields']['field_business_name_1']['label'] = '';

$handler->display->display_options['fields']['field_business_name_1']['element_type'] = 'h1';

$handler->display->display_options['fields']['field_business_name_1']['element_label_colon'] = FALSE;

/ Field: Profile: City /

$handler->display->display_options['fields']['field_city_biz_profile']['id'] = 'field_city_biz_profile';

$handler->display->display_options['fields']['field_city_biz_profile']['table'] = 'field_data_field_city_biz_profile';

$handler->display->display_options['fields']['field_city_biz_profile']['field'] = 'field_city_biz_profile';

$handler->display->display_options['fields']['field_city_biz_profile']['label'] = '';

$handler->display->display_options['fields']['field_city_biz_profile']['element_type'] = 'span';

$handler->display->display_options['fields']['field_city_biz_profile']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_city_biz_profile']['element_label_class'] = 'fontcolorviews';

$handler->display->display_options['fields']['field_city_biz_profile']['element_label_colon'] = FALSE;

$handler->display->display_options['fields']['field_city_biz_profile']['type'] = 'taxonomy_term_reference_plain';

/ Field: Field: US State /

$handler->display->display_options['fields']['field_us_state']['id'] = 'field_us_state';

$handler->display->display_options['fields']['field_us_state']['table'] = 'field_data_field_us_state';

$handler->display->display_options['fields']['field_us_state']['field'] = 'field_us_state';

$handler->display->display_options['fields']['field_us_state']['label'] = '';

$handler->display->display_options['fields']['field_us_state']['element_type'] = 'span';

$handler->display->display_options['fields']['field_us_state']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_us_state']['element_label_class'] = 'fontcolorviews';

$handler->display->display_options['fields']['field_us_state']['element_label_colon'] = FALSE;

$handler->display->display_options['fields']['field_us_state']['hide_empty'] = TRUE;

$handler->display->display_options['fields']['field_us_state']['type'] = 'taxonomy_term_reference_plain';

/ Field: Profile: Country /

$handler->display->display_options['fields']['field_my_country']['id'] = 'field_my_country';

$handler->display->display_options['fields']['field_my_country']['table'] = 'field_data_field_my_country';

$handler->display->display_options['fields']['field_my_country']['field'] = 'field_my_country';

$handler->display->display_options['fields']['field_my_country']['label'] = '';

$handler->display->display_options['fields']['field_my_country']['element_label_colon'] = FALSE;

$handler->display->display_options['fields']['field_my_country']['type'] = 'taxonomy_term_reference_plain';

/ Field: Profile: Industry /

$handler->display->display_options['fields']['field_profile_company_industries']['id'] = 'field_profile_company_industries';

$handler->display->display_options['fields']['field_profile_company_industries']['table'] = 'field_data_field_profile_company_industries';

$handler->display->display_options['fields']['field_profile_company_industries']['field'] = 'field_profile_company_industries';

$handler->display->display_options['fields']['field_profile_company_industries']['element_type'] = 'span';

$handler->display->display_options['fields']['field_profile_company_industries']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_profile_company_industries']['hide_empty'] = TRUE;

$handler->display->display_options['fields']['field_profile_company_industries']['type'] = 'taxonomy_term_reference_plain';

/ Field: Profile: Specialties /

$handler->display->display_options['fields']['field_business_profile_sector_1']['id'] = 'field_business_profile_sector_1';

$handler->display->display_options['fields']['field_business_profile_sector_1']['table'] = 'field_data_field_business_profile_sector';

$handler->display->display_options['fields']['field_business_profile_sector_1']['field'] = 'field_business_profile_sector';

$handler->display->display_options['fields']['field_business_profile_sector_1']['label'] = 'Sectors';

$handler->display->display_options['fields']['field_business_profile_sector_1']['element_type'] = 'span';

$handler->display->display_options['fields']['field_business_profile_sector_1']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_business_profile_sector_1']['hide_empty'] = TRUE;

$handler->display->display_options['fields']['field_business_profile_sector_1']['type'] = 'taxonomy_term_reference_plain';

$handler->display->display_options['fields']['field_business_profile_sector_1']['delta_limit'] = '3';

$handler->display->display_options['fields']['field_business_profile_sector_1']['delta_offset'] = '0';

/ Field: Profile: Founded /

$handler->display->display_options['fields']['field_founded']['id'] = 'field_founded';

$handler->display->display_options['fields']['field_founded']['table'] = 'field_data_field_founded';

$handler->display->display_options['fields']['field_founded']['field'] = 'field_founded';

$handler->display->display_options['fields']['field_founded']['element_type'] = 'span';

$handler->display->display_options['fields']['field_founded']['element_label_type'] = 'strong';

/ Field: Profile: Employees /

$handler->display->display_options['fields']['field_profile_employees']['id'] = 'field_profile_employees';

$handler->display->display_options['fields']['field_profile_employees']['table'] = 'field_data_field_profile_employees';

$handler->display->display_options['fields']['field_profile_employees']['field'] = 'field_profile_employees';

$handler->display->display_options['fields']['field_profile_employees']['element_type'] = 'span';

$handler->display->display_options['fields']['field_profile_employees']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_profile_employees']['hide_empty'] = TRUE;

$handler->display->display_options['fields']['field_profile_employees']['type'] = 'taxonomy_term_reference_plain';

/ Field: Profile: Avg. hourly rate /

$handler->display->display_options['fields']['field_profile_avg_hourly_rate']['id'] = 'field_profile_avg_hourly_rate';

$handler->display->display_options['fields']['field_profile_avg_hourly_rate']['table'] = 'field_data_field_profile_avg_hourly_rate';

$handler->display->display_options['fields']['field_profile_avg_hourly_rate']['field'] = 'field_profile_avg_hourly_rate';

$handler->display->display_options['fields']['field_profile_avg_hourly_rate']['element_type'] = 'span';

$handler->display->display_options['fields']['field_profile_avg_hourly_rate']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_profile_avg_hourly_rate']['hide_empty'] = TRUE;

$handler->display->display_options['fields']['field_profile_avg_hourly_rate']['type'] = 'taxonomy_term_reference_plain';

/ Field: Profile: Minimum project size /

$handler->display->display_options['fields']['field_profile_minimum_project_si']['id'] = 'field_profile_minimum_project_si';

$handler->display->display_options['fields']['field_profile_minimum_project_si']['table'] = 'field_data_field_profile_minimum_project_si';

$handler->display->display_options['fields']['field_profile_minimum_project_si']['field'] = 'field_profile_minimum_project_si';

$handler->display->display_options['fields']['field_profile_minimum_project_si']['element_type'] = 'span';

$handler->display->display_options['fields']['field_profile_minimum_project_si']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_profile_minimum_project_si']['hide_empty'] = TRUE;

$handler->display->display_options['fields']['field_profile_minimum_project_si']['settings'] = array(

'thousand_separator' => '',

'prefix_suffix' => 1,

);

/ Field: Profile: About /

$handler->display->display_options['fields']['field_business_highlights']['id'] = 'field_business_highlights';

$handler->display->display_options['fields']['field_business_highlights']['table'] = 'field_data_field_business_highlights';

$handler->display->display_options['fields']['field_business_highlights']['field'] = 'field_business_highlights';

$handler->display->display_options['fields']['field_business_highlights']['label'] = '';

$handler->display->display_options['fields']['field_business_highlights']['alter']['max_length'] = '300';

$handler->display->display_options['fields']['field_business_highlights']['alter']['more_link'] = TRUE;

$handler->display->display_options['fields']['field_business_highlights']['alter']['more_link_text'] = 'more';

$handler->display->display_options['fields']['field_business_highlights']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_business_highlights']['element_label_class'] = 'fontcolorviews';

$handler->display->display_options['fields']['field_business_highlights']['element_label_colon'] = FALSE;

$handler->display->display_options['fields']['field_business_highlights']['hide_empty'] = TRUE;

$handler->display->display_options['fields']['field_business_highlights']['type'] = 'jquery_expander';

$handler->display->display_options['fields']['field_business_highlights']['settings'] = array(

'expandText' => '...more',

'expandPrefix' => '',

'slicePoint' => '300',

'collapseTimer' => '',

'userCollapseText' => 'less',

'userCollapsePrefix' => '',

);

/ Field: Profile: Services /

$handler->display->display_options['fields']['field_profile_company_services']['id'] = 'field_profile_company_services';

$handler->display->display_options['fields']['field_profile_company_services']['table'] = 'field_data_field_profile_company_services';

$handler->display->display_options['fields']['field_profile_company_services']['field'] = 'field_profile_company_services';

$handler->display->display_options['fields']['field_profile_company_services']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_profile_company_services']['hide_empty'] = TRUE;

$handler->display->display_options['fields']['field_profile_company_services']['type'] = 'taxonomy_term_reference_plain';

$handler->display->display_options['fields']['field_profile_company_services']['delta_offset'] = '0';

/ Field: Profile: Clients /

$handler->display->display_options['fields']['field_profile_company_clients']['id'] = 'field_profile_company_clients';

$handler->display->display_options['fields']['field_profile_company_clients']['table'] = 'field_data_field_profile_company_clients';

$handler->display->display_options['fields']['field_profile_company_clients']['field'] = 'field_profile_company_clients';

$handler->display->display_options['fields']['field_profile_company_clients']['element_type'] = 'span';

$handler->display->display_options['fields']['field_profile_company_clients']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_profile_company_clients']['hide_empty'] = TRUE;

$handler->display->display_options['fields']['field_profile_company_clients']['type'] = 'taxonomy_term_reference_plain';

$handler->display->display_options['fields']['field_profile_company_clients']['delta_offset'] = '0';

/ Field: Profile: Awards /

$handler->display->display_options['fields']['field_profile_company_awards']['id'] = 'field_profile_company_awards';

$handler->display->display_options['fields']['field_profile_company_awards']['table'] = 'field_data_field_profile_company_awards';

$handler->display->display_options['fields']['field_profile_company_awards']['field'] = 'field_profile_company_awards';

$handler->display->display_options['fields']['field_profile_company_awards']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_profile_company_awards']['hide_empty'] = TRUE;

$handler->display->display_options['fields']['field_profile_company_awards']['delta_offset'] = '0';

/ Field: Profile: Address /

$handler->display->display_options['fields']['field_business_address']['id'] = 'field_business_address';

$handler->display->display_options['fields']['field_business_address']['table'] = 'field_data_field_business_address';

$handler->display->display_options['fields']['field_business_address']['field'] = 'field_business_address';

$handler->display->display_options['fields']['field_business_address']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_business_address']['element_label_class'] = 'fontcolorviews';

$handler->display->display_options['fields']['field_business_address']['hide_empty'] = TRUE;

/ Field: Profile: Phone /

$handler->display->display_options['fields']['field_phone']['id'] = 'field_phone';

$handler->display->display_options['fields']['field_phone']['table'] = 'field_data_field_phone';

$handler->display->display_options['fields']['field_phone']['field'] = 'field_phone';

$handler->display->display_options['fields']['field_phone']['element_type'] = 'span';

$handler->display->display_options['fields']['field_phone']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_phone']['element_label_class'] = 'fontcolorviews';

$handler->display->display_options['fields']['field_phone']['hide_empty'] = TRUE;

$handler->display->display_options['fields']['field_phone']['type'] = 'text_plain';

/ Field: Field: Website /

$handler->display->display_options['fields']['field_business_link_1']['id'] = 'field_business_link_1';

$handler->display->display_options['fields']['field_business_link_1']['table'] = 'field_data_field_business_link';

$handler->display->display_options['fields']['field_business_link_1']['field'] = 'field_business_link';

$handler->display->display_options['fields']['field_business_link_1']['label'] = 'Web';

$handler->display->display_options['fields']['field_business_link_1']['element_type'] = 'span';

$handler->display->display_options['fields']['field_business_link_1']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_business_link_1']['element_label_class'] = 'fontcolorviews';

$handler->display->display_options['fields']['field_business_link_1']['hide_empty'] = TRUE;

$handler->display->display_options['fields']['field_business_link_1']['click_sort_column'] = 'url';

$handler->display->display_options['fields']['field_business_link_1']['type'] = 'link_url';

/ Field: Profile: Social links /

$handler->display->display_options['fields']['field_social_links']['id'] = 'field_social_links';

$handler->display->display_options['fields']['field_social_links']['table'] = 'field_data_field_social_links';

$handler->display->display_options['fields']['field_social_links']['field'] = 'field_social_links';

$handler->display->display_options['fields']['field_social_links']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_social_links']['click_sort_column'] = 'url';

$handler->display->display_options['fields']['field_social_links']['type'] = 'link_url';

$handler->display->display_options['fields']['field_social_links']['settings'] = array(

'custom_title' => '',

);

$handler->display->display_options['fields']['field_social_links']['delta_offset'] = '0';

$handler->display->display_options['fields']['field_social_links']['separator'] = '

';

/ Field: Profile: Work enquiry /

$handler->display->display_options['fields']['field_work_enquiry']['id'] = 'field_work_enquiry';

$handler->display->display_options['fields']['field_work_enquiry']['table'] = 'field_data_field_work_enquiry';

$handler->display->display_options['fields']['field_work_enquiry']['field'] = 'field_work_enquiry';

$handler->display->display_options['fields']['field_work_enquiry']['element_label_type'] = 'strong';

/ Field: Profile: Web references /

$handler->display->display_options['fields']['field_web_references']['id'] = 'field_web_references';

$handler->display->display_options['fields']['field_web_references']['table'] = 'field_data_field_web_references';

$handler->display->display_options['fields']['field_web_references']['field'] = 'field_web_references';

$handler->display->display_options['fields']['field_web_references']['element_label_type'] = 'strong';

$handler->display->display_options['fields']['field_web_references']['click_sort_column'] = 'url';

$handler->display->display_options['fields']['field_web_references']['type'] = 'link_separate';

$handler->display->display_options['fields']['field_web_references']['settings'] = array(

'custom_title' => '',

);

$handler->display->display_options['fields']['field_web_references']['delta_offset'] = '0';

$handler->display->display_options['fields']['field_web_references']['separator'] = '';

/ Field: Profile: Email anonymous /

$handler->display->display_options['fields']['field_profile_email_anonymous']['id'] = 'field_profile_email_anonymous';

$handler->display->display_options['fields']['field_profile_email_anonymous']['table'] = 'field_data_field_profile_email_anonymous';

$handler->display->display_options['fields']['field_profile_email_anonymous']['field'] = 'field_profile_email_anonymous';

$handler->display->display_options['fields']['field_profile_email_anonymous']['label'] = '';

$handler->display->display_options['fields']['field_profile_email_anonymous']['element_label_colon'] = FALSE;

/ Field: Flags: Flag link /

$handler->display->display_options['fields']['ops']['id'] = 'ops';

$handler->display->display_options['fields']['ops']['table'] = 'flagging';

$handler->display->display_options['fields']['ops']['field'] = 'ops';

$handler->display->display_options['fields']['ops']['relationship'] = 'flag_content_rel';

/ Contextual filter: Profile: User uid /

$handler->display->display_options['arguments']['user']['id'] = 'user';

$handler->display->display_options['arguments']['user']['table'] = 'profile';

$handler->display->display_options['arguments']['user']['field'] = 'user';

$handler->display->display_options['arguments']['user']['default_action'] = 'default';

$handler->display->display_options['arguments']['user']['default_argument_type'] = 'user';

$handler->display->display_options['arguments']['user']['default_argument_options']['user'] = FALSE;

$handler->display->display_options['arguments']['user']['summary']['number_of_records'] = '0';

$handler->display->display_options['arguments']['user']['summary']['format'] = 'default_summary';

$handler->display->display_options['arguments']['user']['summary_options']['items_per_page'] = '25';

/ Filter criterion: Profile: Type /

$handler->display->display_options['filters']['type']['id'] = 'type';

$handler->display->display_options['filters']['type']['table'] = 'profile';

$handler->display->display_options['filters']['type']['field'] = 'type';

$handler->display->display_options['filters']['type']['value'] = array(

'main' => 'main',

);