topic Re: Need help in QlikView https://community.qlik.com/t5/QlikView/Need-help/m-p/77609#M789656 <HTML><HEAD></HEAD><BODY><P>Hello Tresesco,</P><P></P><P>Thanks for ur reply,</P><P>I am getting <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">CONCAT(<STRONG>Distinct</STRONG> {1&lt;<STRONG>M</STRONG>ID=P(ID)&gt;}<STRONG>S</STRONG>ID, ',')</SPAN> and <STRONG>COUNT fieldS</STRONG> but not getting SID and MID values.</P></BODY></HTML> Fri, 09 Feb 2018 05:47:46 GMT gireesh1216 2018-02-09T05:47:46Z Need help https://community.qlik.com/t5/QlikView/Need-help/m-p/77607#M789654 <HTML><HEAD></HEAD><BODY><P>Hello Team,</P><P>I have a table like below:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>MID</STRONG></TH></TR><TR><TD style="padding: 2px;">1216</TD><TD style="padding: 2px;">1217</TD><TD style="padding: 2px;">1218</TD></TR><TR><TD style="padding: 2px;">1219</TD><TD style="padding: 2px;">1222</TD><TD style="padding: 2px;">1223</TD></TR><TR><TD style="padding: 2px;">1220</TD><TD style="padding: 2px;">1222</TD><TD style="padding: 2px;">1223</TD></TR><TR><TD style="padding: 2px;">1221</TD><TD style="padding: 2px;">1224</TD><TD style="padding: 2px;">1225</TD></TR><TR><TD style="padding: 2px;">1222</TD><TD style="padding: 2px;">1217</TD><TD style="padding: 2px;">1218</TD></TR><TR><TD style="padding: 2px;">1224</TD><TD style="padding: 2px;">1223</TD><TD style="padding: 2px;">1218</TD></TR><TR><TD style="padding: 2px;">1225</TD><TD style="padding: 2px;">1223</TD><TD style="padding: 2px;">1218</TD></TR><TR><TD style="padding: 2px;">1218</TD><TD style="padding: 2px;">1223</TD><TD style="padding: 2px;">1225</TD></TR><TR><TD style="padding: 2px;">1223</TD><TD style="padding: 2px;">NULL</TD><TD style="padding: 2px;">1225</TD></TR></TBODY></TABLE><P></P><P></P><P><STRONG>OUTPUT</STRONG>: <STRONG>If I select 1218 from ID field</STRONG> I WANT OUTPUT LIKE BELOW:</P><P>EXPRESSION:CONCAT({1&lt;SID=P(ID)&gt;}ID)</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>MID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>CONCAT({1&lt;SID=P(ID)&gt;}ID)</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>COUNT</STRONG></TH></TR><TR><TD style="padding: 2px;">1218</TD><TD style="padding: 2px;">1223</TD><TD style="padding: 2px;">1225</TD><TD style="padding: 2px;">1217,1223</TD><TD style="padding: 2px;">2</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/77607#M789654 gireesh1216 2020-11-25T16:16:04Z Re: Need help https://community.qlik.com/t5/QlikView/Need-help/m-p/77608#M789655 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">CONCAT(<STRONG>Distinct</STRONG> {1&lt;<STRONG>M</STRONG>ID=P(ID)&gt;}<STRONG>S</STRONG>ID, ',')</SPAN></P></BODY></HTML> Fri, 09 Feb 2018 05:39:03 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/77608#M789655 tresB 2018-02-09T05:39:03Z Re: Need help https://community.qlik.com/t5/QlikView/Need-help/m-p/77609#M789656 <HTML><HEAD></HEAD><BODY><P>Hello Tresesco,</P><P></P><P>Thanks for ur reply,</P><P>I am getting <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">CONCAT(<STRONG>Distinct</STRONG> {1&lt;<STRONG>M</STRONG>ID=P(ID)&gt;}<STRONG>S</STRONG>ID, ',')</SPAN> and <STRONG>COUNT fieldS</STRONG> but not getting SID and MID values.</P></BODY></HTML> Fri, 09 Feb 2018 05:47:46 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/77609#M789656 gireesh1216 2018-02-09T05:47:46Z Re: Need help https://community.qlik.com/t5/QlikView/Need-help/m-p/77610#M789657 <HTML><HEAD></HEAD><BODY><P>PFA</P><P></P><P>Try with '<STRONG>Total</STRONG>'</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Concat( <STRONG>Total</STRONG> </SPAN>Distinct<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> {1&lt;</SPAN>M<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ID=P(ID)&gt;}</SPAN>S<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ID, ',')</SPAN></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192924_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 09 Feb 2018 06:01:52 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/77610#M789657 tresB 2018-02-09T06:01:52Z Re: Need help https://community.qlik.com/t5/QlikView/Need-help/m-p/77611#M789658 <HTML><HEAD></HEAD><BODY><P>Thank you so much:)</P></BODY></HTML> Fri, 09 Feb 2018 06:14:34 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/77611#M789658 gireesh1216 2018-02-09T06:14:34Z