https://community.qlik.com/t5/App-Development/Unique-Filter-Options/m-p/1784956#M61191 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/58236">@Gabe_Miller</a>&nbsp;</P><P>In Script you can do for example :</P><P>&nbsp;</P><LI-CODE lang="python">Data: Load field, mid(field,IterNo(),1) as UniqueField While iterno()&lt;=Len(field); load * inline [ field a ab abc abcd b bc bcd ]</LI-CODE><P>&nbsp;</P><P>output:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_0-1614027341791.png"><img src="https://community.qlik.com/skins/images/C5FA59D18544CB42600F6BC5E9F00E2B/responsive_peak/images/image_not_found.png" alt="Taoufiq_Zarra_0-1614027341791.png" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_1-1614027360788.png"><img src="https://community.qlik.com/skins/images/C5FA59D18544CB42600F6BC5E9F00E2B/responsive_peak/images/image_not_found.png" alt="Taoufiq_Zarra_1-1614027360788.png" /></span></P><P>&nbsp;</P> Mon, 22 Feb 2021 20:59:53 GMT Taoufiq_Zarra 2021-02-22T20:59:53Z https://community.qlik.com/t5/App-Development/Unique-Filter-Options/m-p/1784881#M61184 <P>Hello, I am needing to create a filter for a dimension with multiple options as described below:</P><P>field:<BR />a,<BR />ab,<BR />abc,<BR />abcd,<BR />b,<BR />bc,<BR />bcd</P><P>How do I create a filter to show:<BR />a<BR />b<BR />c<BR />d</P><P>So selecting option 'b' would bring up all values that include b?</P> Sat, 16 Nov 2024 00:33:18 GMT https://community.qlik.com/t5/App-Development/Unique-Filter-Options/m-p/1784881#M61184 Gabe_Miller 2024-11-16T00:33:18Z https://community.qlik.com/t5/App-Development/Unique-Filter-Options/m-p/1784956#M61191 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/58236">@Gabe_Miller</a>&nbsp;</P><P>In Script you can do for example :</P><P>&nbsp;</P><LI-CODE lang="python">Data: Load field, mid(field,IterNo(),1) as UniqueField While iterno()&lt;=Len(field); load * inline [ field a ab abc abcd b bc bcd ]</LI-CODE><P>&nbsp;</P><P>output:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_0-1614027341791.png"><img src="https://community.qlik.com/skins/images/C5FA59D18544CB42600F6BC5E9F00E2B/responsive_peak/images/image_not_found.png" alt="Taoufiq_Zarra_0-1614027341791.png" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_1-1614027360788.png"><img src="https://community.qlik.com/skins/images/C5FA59D18544CB42600F6BC5E9F00E2B/responsive_peak/images/image_not_found.png" alt="Taoufiq_Zarra_1-1614027360788.png" /></span></P><P>&nbsp;</P> Mon, 22 Feb 2021 20:59:53 GMT https://community.qlik.com/t5/App-Development/Unique-Filter-Options/m-p/1784956#M61191 Taoufiq_Zarra 2021-02-22T20:59:53Z