topic Re: Common string problem in Ad HOc reporting in QlikView https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332106#M411397 <HTML><HEAD></HEAD><BODY><P>this is not mandatory you can ignore this</P></BODY></HTML> Wed, 21 Jun 2017 09:54:35 GMT mayankraoka 2017-06-21T09:54:35Z Common string problem in Ad HOc reporting https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332101#M411392 <HTML><HEAD></HEAD><BODY><P>Hi Friends, </P><P></P><P>I have 2 dimensions name </P><P></P><P>Country</P><P>Country Description</P><P></P><P>now i have created ad hoc report and when i am selection Country Description then country dimension is also activating , please help .</P><P></P><P></P><P></P><P>=SubStringCount(concat(%Dimensions_Geo,'|'),'Country')</P><P><SPAN style="font-size: 13.3333px;">=SubStringCount(concat(%Dimensions_Geo,'|'),'Country Description')</SPAN></P><P></P><P>i have also tried </P><P></P><P>=SubStringCount(concat(hash256(%Dimensions_Geo),'|'),hash256('Country'))</P><P><SPAN style="font-size: 13.3333px;">=SubStringCount(concat(hash256(%Dimensions_Geo),'|'),hash256('Country <SPAN style="font-size: 13.3333px;">Description</SPAN>'))</SPAN></P></BODY></HTML> Wed, 21 Jun 2017 08:38:08 GMT https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332101#M411392 agni_gold 2017-06-21T08:38:08Z Re: Common string problem in Ad HOc reporting https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332102#M411393 <HTML><HEAD></HEAD><BODY><P>Hi Agnivesh,</P><P></P><P>Can you try this:</P><P>=SubStringCount(Concat(GetFieldSelections(Dimensions, '|',20), '|'),'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Country</SPAN>')</P><P>SubStringCount(Concat(GetFieldSelections(Dimensions, '|',20), '|'),'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Country Description</SPAN>')</P><P></P><P>Regards,</P><P>Mayank</P></BODY></HTML> Wed, 21 Jun 2017 08:47:16 GMT https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332102#M411393 mayankraoka 2017-06-21T08:47:16Z Re: Common string problem in Ad HOc reporting https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332103#M411394 <HTML><HEAD></HEAD><BODY><P>Try these</P><P></P><P><STRONG>=SubStringCount(Concat(<SPAN style="color: #ff0000;">DISTINCT '|' &amp;</SPAN> %Dimensions_Geo <SPAN style="color: #ff0000;">&amp; '|'</SPAN>),'<SPAN style="color: #ff0000;">|</SPAN>Country<SPAN style="color: #ff0000;">|</SPAN>')</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>=SubStringCount(C<STRONG style="font-size: 13.3333px;">oncat(<SPAN style="color: #ff0000;">DISTINCT '|' &amp;</SPAN> %Dimensions_Geo <SPAN style="color: #ff0000;">&amp; '|'</SPAN>)</STRONG>,'<STRONG style="color: #ff0000; font-size: 13.3333px;">|</STRONG>Country Description<STRONG style="color: #ff0000; font-size: 13.3333px;">|</STRONG>')</STRONG></P></BODY></HTML> Wed, 21 Jun 2017 08:48:14 GMT https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332103#M411394 sunny_talwar 2017-06-21T08:48:14Z Re: Common string problem in Ad HOc reporting https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332104#M411395 <HTML><HEAD></HEAD><BODY><P>what 20 is doing ?</P></BODY></HTML> Wed, 21 Jun 2017 08:52:58 GMT https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332104#M411395 agni_gold 2017-06-21T08:52:58Z Re: Common string problem in Ad HOc reporting https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332105#M411396 <HTML><HEAD></HEAD><BODY><P>I have Country stored in one variable and country Description stored in another variable&nbsp; , </P><P>but it is not working </P><P></P><P>=SubStringCount(concat(distinct '|'&amp;%Dimensions_Geo&amp;'|'),'|'&amp;vL_FN_Dimension_Geo3&amp;'|') </P><P>=SubStringCount(concat(distinct '|'&amp;%Dimensions_Geo&amp;'|'),'|'&amp;vL_FN_Dimension_Geo4&amp;'|') </P></BODY></HTML> Wed, 21 Jun 2017 09:51:48 GMT https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332105#M411396 agni_gold 2017-06-21T09:51:48Z Re: Common string problem in Ad HOc reporting https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332106#M411397 <HTML><HEAD></HEAD><BODY><P>this is not mandatory you can ignore this</P></BODY></HTML> Wed, 21 Jun 2017 09:54:35 GMT https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332106#M411397 mayankraoka 2017-06-21T09:54:35Z Re: Common string problem in Ad HOc reporting https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332107#M411398 <HTML><HEAD></HEAD><BODY><P>its not working </P></BODY></HTML> Wed, 21 Jun 2017 10:09:33 GMT https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332107#M411398 agni_gold 2017-06-21T10:09:33Z Re: Common string problem in Ad HOc reporting https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332108#M411399 <HTML><HEAD></HEAD><BODY><P>Can you share a sample?</P></BODY></HTML> Wed, 21 Jun 2017 11:12:16 GMT https://community.qlik.com/t5/QlikView/Common-string-problem-in-Ad-HOc-reporting/m-p/1332108#M411399 sunny_talwar 2017-06-21T11:12:16Z