topic Re: merging two pie chart sections into one in QlikView https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663787#M241768 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This fixes your first part</P><P></P><P>=IF(Ethnicity='NULL' or Ethnicity='Unknown','New Group',Ethnicity)</P><P></P><P>Working on second post</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 26 Jun 2014 17:55:05 GMT ashfaq_haseeb 2014-06-26T17:55:05Z merging two pie chart sections into one https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663782#M241763 <HTML><HEAD></HEAD><BODY><P>I have a Null section and a unknown section. I want to merge them together. I am new to Qlikview expressions so if that is the problem please explain thoroughly. THANKS! </P></BODY></HTML> Thu, 26 Jun 2014 16:40:25 GMT https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663782#M241763 2014-06-26T16:40:25Z Re: merging two pie chart sections into one https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663783#M241764 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you post your dimensions and expression here.</P><P>Or If possible post your sample file here</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 26 Jun 2014 16:42:01 GMT https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663783#M241764 ashfaq_haseeb 2014-06-26T16:42:01Z Re: merging two pie chart sections into one https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663784#M241765 <HTML><HEAD></HEAD><BODY><P><IMG alt="expressoin.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/61288_expressoin.png" style="width: 620px; height: 515px;" /></P></BODY></HTML> Thu, 26 Jun 2014 16:50:54 GMT https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663784#M241765 2014-06-26T16:50:54Z Re: merging two pie chart sections into one https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663785#M241766 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P></P><P>add below calculated dimension instead of your dimension</P><P></P><P>=If(Isnull([Dimension Field]).or [Dimension Field]='Unknown' or [Dimension Field]='Null','New Selection', [Dimension Field])</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 26 Jun 2014 16:58:52 GMT https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663785#M241766 ashfaq_haseeb 2014-06-26T16:58:52Z Re: merging two pie chart sections into one https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663786#M241767 <HTML><HEAD></HEAD><BODY><P>this combined all the sections. I want to only combine null and unknown.</P></BODY></HTML> Thu, 26 Jun 2014 17:22:30 GMT https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663786#M241767 2014-06-26T17:22:30Z Re: merging two pie chart sections into one https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663787#M241768 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This fixes your first part</P><P></P><P>=IF(Ethnicity='NULL' or Ethnicity='Unknown','New Group',Ethnicity)</P><P></P><P>Working on second post</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 26 Jun 2014 17:55:05 GMT https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663787#M241768 ashfaq_haseeb 2014-06-26T17:55:05Z Re: merging two pie chart sections into one https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663788#M241769 <HTML><HEAD></HEAD><BODY><P>can you send me the file with the fixed issues its still not working.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 26 Jun 2014 18:18:50 GMT https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663788#M241769 2014-06-26T18:18:50Z Re: merging two pie chart sections into one https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663789#M241770 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Its attached in another post.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 26 Jun 2014 18:20:49 GMT https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663789#M241770 ashfaq_haseeb 2014-06-26T18:20:49Z Re: merging two pie chart sections into one https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663790#M241771 <HTML><HEAD></HEAD><BODY><P>You can delete it</P></BODY></HTML> Thu, 26 Jun 2014 18:29:04 GMT https://community.qlik.com/t5/QlikView/merging-two-pie-chart-sections-into-one/m-p/663790#M241771 2014-06-26T18:29:04Z