topic Check the last value of a string inside the function aggr (Concat (FIELD_A, '',FIELD_B), FIELD_C) in QlikView https://community.qlik.com/t5/QlikView/Check-the-last-value-of-a-string-inside-the-function-aggr-Concat/m-p/777162#M275470 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Good morning</SPAN>, <SPAN class="hps">I have</SPAN> <SPAN class="hps">the following problem</SPAN>:</SPAN></P><P><SPAN lang="en"><BR /><SPAN class="hps">Using the</SPAN> <SPAN class="hps">aggr</SPAN> <SPAN class="atn hps">(</SPAN>Concat <SPAN class="atn hps">(</SPAN>DISTINCT FIELD_A, <SPAN class="atn hps">'</SPAN>', <SPAN lang="en">FIELD_B</SPAN>), <SPAN lang="en">FIELD_C</SPAN>) <SPAN class="hps">should</SPAN> <SPAN class="hps">check</SPAN> <SPAN class="hps">the last</SPAN> <SPAN class="hps">field value</SPAN> <SPAN lang="en">FIELD_A</SPAN>.<BR /><SPAN class="hps">In case there's</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">number</SPAN> <SPAN class="hps">I should put</SPAN> <SPAN class="hps">a</SPAN>., and <SPAN class="hps">if there was a</SPAN> <SPAN class="hps">letter</SPAN> <SPAN class="hps">I should not</SPAN> <SPAN class="hps">put anything</SPAN> <SPAN class="hps">as a separator</SPAN>.<BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">It's possible to define <SPAN class="hps">a condition</SPAN> <SPAN class="hps">on that?</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps">Thanks</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps">Giovanni Scalzo<BR /></SPAN></SPAN></P></BODY></HTML> Tue, 10 Feb 2015 13:54:43 GMT 2015-02-10T13:54:43Z Check the last value of a string inside the function aggr (Concat (FIELD_A, '',FIELD_B), FIELD_C) https://community.qlik.com/t5/QlikView/Check-the-last-value-of-a-string-inside-the-function-aggr-Concat/m-p/777162#M275470 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Good morning</SPAN>, <SPAN class="hps">I have</SPAN> <SPAN class="hps">the following problem</SPAN>:</SPAN></P><P><SPAN lang="en"><BR /><SPAN class="hps">Using the</SPAN> <SPAN class="hps">aggr</SPAN> <SPAN class="atn hps">(</SPAN>Concat <SPAN class="atn hps">(</SPAN>DISTINCT FIELD_A, <SPAN class="atn hps">'</SPAN>', <SPAN lang="en">FIELD_B</SPAN>), <SPAN lang="en">FIELD_C</SPAN>) <SPAN class="hps">should</SPAN> <SPAN class="hps">check</SPAN> <SPAN class="hps">the last</SPAN> <SPAN class="hps">field value</SPAN> <SPAN lang="en">FIELD_A</SPAN>.<BR /><SPAN class="hps">In case there's</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">number</SPAN> <SPAN class="hps">I should put</SPAN> <SPAN class="hps">a</SPAN>., and <SPAN class="hps">if there was a</SPAN> <SPAN class="hps">letter</SPAN> <SPAN class="hps">I should not</SPAN> <SPAN class="hps">put anything</SPAN> <SPAN class="hps">as a separator</SPAN>.<BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">It's possible to define <SPAN class="hps">a condition</SPAN> <SPAN class="hps">on that?</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps">Thanks</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps">Giovanni Scalzo<BR /></SPAN></SPAN></P></BODY></HTML> Tue, 10 Feb 2015 13:54:43 GMT https://community.qlik.com/t5/QlikView/Check-the-last-value-of-a-string-inside-the-function-aggr-Concat/m-p/777162#M275470 2015-02-10T13:54:43Z