topic repeatative digits in QlikView https://community.qlik.com/t5/QlikView/repeatative-digits/m-p/200616#M59084 <HTML><HEAD></HEAD><BODY><P>thanks</P></BODY></HTML> Tue, 29 Sep 2009 19:56:57 GMT mah_1356 2009-09-29T19:56:57Z repeatative digits https://community.qlik.com/t5/QlikView/repeatative-digits/m-p/200614#M59082 <HTML><HEAD></HEAD><BODY><P>hi</P><P>I have a field that contain numeric value<BR />I want to filter the data that have 9 digit or lower or have repeative digits such as 1111 or 22222<BR />thanks</P></BODY></HTML> Mon, 28 Sep 2009 19:19:49 GMT https://community.qlik.com/t5/QlikView/repeatative-digits/m-p/200614#M59082 mah_1356 2009-09-28T19:19:49Z repeatative digits https://community.qlik.com/t5/QlikView/repeatative-digits/m-p/200615#M59083 <HTML><HEAD></HEAD><BODY><P>As this is more a text-analysis would<BR />1. convert the number into a text (TEXT()-funtion), e.g. TEXT(Field) AS MyField<BR />2. Filter this text then with the LEN()-function. e.g. LEN(MyField) &lt; 9<BR />3. Filter this text then with WILDMATCH()-function, e.g. WILDMATCH(MyField, '1111*', '22222*')</P><P>HTH<BR />Peter</P></BODY></HTML> Mon, 28 Sep 2009 19:30:30 GMT https://community.qlik.com/t5/QlikView/repeatative-digits/m-p/200615#M59083 prieper 2009-09-28T19:30:30Z repeatative digits https://community.qlik.com/t5/QlikView/repeatative-digits/m-p/200616#M59084 <HTML><HEAD></HEAD><BODY><P>thanks</P></BODY></HTML> Tue, 29 Sep 2009 19:56:57 GMT https://community.qlik.com/t5/QlikView/repeatative-digits/m-p/200616#M59084 mah_1356 2009-09-29T19:56:57Z