topic Conditional dimensions - similar names in listbox in QlikView https://community.qlik.com/t5/QlikView/Conditional-dimensions-similar-names-in-listbox/m-p/445333#M166108 <HTML><HEAD></HEAD><BODY><P>Hello developers,</P><P></P><P>could anybody please give me any advice about my problem? Maybe someone already met this.</P><P></P><P>I have dimensions in listbox which are similar. That mean that some of them contains same words.</P><P></P><P>Customer</P><P>Customer Phone</P><P>Customer Country</P><P></P><P><SPAN style="color: #ff0000;">When "Customer phone" is selected, in table "Customer" will appear as well.</SPAN> Is there any chance to use theese similar names in list box with dimensions? Now is this conditional expression in use:</P><P></P><P>=SubStringCount(Concat(Fields, '|'), 'Customer')</P><P></P><P></P><P>Thank you!</P></BODY></HTML> Fri, 15 Mar 2013 11:07:45 GMT 2013-03-15T11:07:45Z Conditional dimensions - similar names in listbox https://community.qlik.com/t5/QlikView/Conditional-dimensions-similar-names-in-listbox/m-p/445333#M166108 <HTML><HEAD></HEAD><BODY><P>Hello developers,</P><P></P><P>could anybody please give me any advice about my problem? Maybe someone already met this.</P><P></P><P>I have dimensions in listbox which are similar. That mean that some of them contains same words.</P><P></P><P>Customer</P><P>Customer Phone</P><P>Customer Country</P><P></P><P><SPAN style="color: #ff0000;">When "Customer phone" is selected, in table "Customer" will appear as well.</SPAN> Is there any chance to use theese similar names in list box with dimensions? Now is this conditional expression in use:</P><P></P><P>=SubStringCount(Concat(Fields, '|'), 'Customer')</P><P></P><P></P><P>Thank you!</P></BODY></HTML> Fri, 15 Mar 2013 11:07:45 GMT https://community.qlik.com/t5/QlikView/Conditional-dimensions-similar-names-in-listbox/m-p/445333#M166108 2013-03-15T11:07:45Z Re: Conditional dimensions - similar names in listbox https://community.qlik.com/t5/QlikView/Conditional-dimensions-similar-names-in-listbox/m-p/445334#M166109 <HTML><HEAD></HEAD><BODY><P>Hi mirek,</P><P></P><P>PFA,&nbsp; Hope Needful has been done.</P><P></P><P>Regards,</P><P>Nirmal.</P></BODY></HTML> Fri, 15 Mar 2013 11:16:46 GMT https://community.qlik.com/t5/QlikView/Conditional-dimensions-similar-names-in-listbox/m-p/445334#M166109 2013-03-15T11:16:46Z Re: Conditional dimensions - similar names in listbox https://community.qlik.com/t5/QlikView/Conditional-dimensions-similar-names-in-listbox/m-p/445335#M166110 <HTML><HEAD></HEAD><BODY><P>Hi nirmal.j,</P><P></P><P>thank you for your reply. Your solution is one of possible solutions, but then appearance of dimensions is changed. I figured this solution:</P><P></P><P>Instead this:</P><P>=SubStringCount(Concat(Fields, '|'), 'Customer')</P><P></P><P>This:</P><P>=SubStringCount(Concat(Fields, '|')&amp;'|', 'Customer|')</P><P></P><P></P><P>Have a nice day!</P></BODY></HTML> Fri, 15 Mar 2013 13:25:46 GMT https://community.qlik.com/t5/QlikView/Conditional-dimensions-similar-names-in-listbox/m-p/445335#M166110 2013-03-15T13:25:46Z