topic Re: Aggregate projectnumbers in QlikView https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352879#M130947 <HTML><HEAD></HEAD><BODY><P>12015555 and 12015555A -&gt; 1201555 and 12014444 and 12014444-A -&gt; 12014444 </P></BODY></HTML> Fri, 15 Jun 2012 08:35:27 GMT 2012-06-15T08:35:27Z Aggregate projectnumbers https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352873#M130941 <HTML><HEAD></HEAD><BODY><P>Hello can someone help me out?</P><P>I've got a projectlist with double numbers i want to aggregate.</P><P>For example 12015501 and 12015501-A to make one number together.</P></BODY></HTML> Thu, 14 Jun 2012 08:52:21 GMT https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352873#M130941 2012-06-14T08:52:21Z Re: Aggregate projectnumbers https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352874#M130942 <HTML><HEAD></HEAD><BODY><P>Check the attached file</P></BODY></HTML> Thu, 14 Jun 2012 09:07:48 GMT https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352874#M130942 sivarajs 2012-06-14T09:07:48Z Re: Aggregate projectnumbers https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352875#M130943 <HTML><HEAD></HEAD><BODY><P>Many thanks.</P></BODY></HTML> Thu, 14 Jun 2012 09:14:36 GMT https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352875#M130943 2012-06-14T09:14:36Z Re: Aggregate projectnumbers https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352876#M130944 <HTML><HEAD></HEAD><BODY><P>Can you helpp me again?</P><P></P><P>Now i've got different types of projectnumber like, 12015555A and 12014444-A together. </P></BODY></HTML> Fri, 15 Jun 2012 08:07:16 GMT https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352876#M130944 2012-06-15T08:07:16Z Re: Aggregate projectnumbers https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352877#M130945 <HTML><HEAD></HEAD><BODY><P>Can you helpp me again?</P><P></P><P>Now i've got different types of projectnumber like, 12015555A and 12014444-A together. </P></BODY></HTML> Fri, 15 Jun 2012 08:28:36 GMT https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352877#M130945 2012-06-15T08:28:36Z Re: Aggregate projectnumbers https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352878#M130946 <HTML><HEAD></HEAD><BODY><P>How you want to group </P><P>12015555A --&gt;12014444-A or</P><P>12014444-A --&gt; 12015555A </P><P></P><P>Because number varying here you need to be clear on that</P></BODY></HTML> Fri, 15 Jun 2012 08:32:07 GMT https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352878#M130946 sivarajs 2012-06-15T08:32:07Z Re: Aggregate projectnumbers https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352879#M130947 <HTML><HEAD></HEAD><BODY><P>12015555 and 12015555A -&gt; 1201555 and 12014444 and 12014444-A -&gt; 12014444 </P></BODY></HTML> Fri, 15 Jun 2012 08:35:27 GMT https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352879#M130947 2012-06-15T08:35:27Z Re: Aggregate projectnumbers https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352880#M130948 <HTML><HEAD></HEAD><BODY><P>try this <SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Right</SPAN><SPAN style="font-size: 8pt;">('120555A',1)&gt;0,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">left</SPAN><SPAN style="font-size: 8pt;">('120555A',</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">index</SPAN><SPAN style="font-size: 8pt;">('120555A',</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Right</SPAN><SPAN style="font-size: 8pt;">('120555A',1))-1),'') </SPAN></P></BODY></HTML> Fri, 15 Jun 2012 10:01:56 GMT https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352880#M130948 sivarajs 2012-06-15T10:01:56Z Re: Aggregate projectnumbers https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352881#M130949 <HTML><HEAD></HEAD><BODY><P>Please check the attachement</P></BODY></HTML> Fri, 15 Jun 2012 10:28:08 GMT https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352881#M130949 2012-06-15T10:28:08Z Re: Aggregate projectnumbers https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352882#M130950 <HTML><HEAD></HEAD><BODY><P>Try this sample</P></BODY></HTML> Fri, 15 Jun 2012 14:37:10 GMT https://community.qlik.com/t5/QlikView/Aggregate-projectnumbers/m-p/352882#M130950 sivarajs 2012-06-15T14:37:10Z