topic Number repetition in the value in QlikView https://community.qlik.com/t5/QlikView/Number-repetition-in-the-value/m-p/300091#M1198609 <HTML><HEAD></HEAD><BODY><P>I am looking for a function which allow me to identify the number of repitition of 3 in a value of field "Performance" also the value should not contains greater then 3 number. for example</P><P>Performance RESULT<BR />Value 1: 000111122322232221111 3 IS REPETING MORE THEN 1 TIME SO RESULT SHOULD BE "NO"<BR />Value 2: 000123456789999999999 VALUE CONTAIN GREATER THEN 3 VALUE SO RESULT SHOULD BE "NO"<BR />Value 3: 000100000001222220001 RESULT IS "YES" AS THE VALUE DOES NOT CONTAIN GREATER THEN 3 NUMBER<BR />Value 4: 000111112222223221121 SAME AS ABOVE RESULT SHOULD BE YES AS VALUE CONTAIN REPETITION OF 3 AT ONCE</P><P>Would appreciate your help on the above query</P><P>Shumail</P><P></P><P></P></BODY></HTML> Sun, 16 Jan 2011 09:47:16 GMT shumailh 2011-01-16T09:47:16Z Number repetition in the value https://community.qlik.com/t5/QlikView/Number-repetition-in-the-value/m-p/300091#M1198609 <HTML><HEAD></HEAD><BODY><P>I am looking for a function which allow me to identify the number of repitition of 3 in a value of field "Performance" also the value should not contains greater then 3 number. for example</P><P>Performance RESULT<BR />Value 1: 000111122322232221111 3 IS REPETING MORE THEN 1 TIME SO RESULT SHOULD BE "NO"<BR />Value 2: 000123456789999999999 VALUE CONTAIN GREATER THEN 3 VALUE SO RESULT SHOULD BE "NO"<BR />Value 3: 000100000001222220001 RESULT IS "YES" AS THE VALUE DOES NOT CONTAIN GREATER THEN 3 NUMBER<BR />Value 4: 000111112222223221121 SAME AS ABOVE RESULT SHOULD BE YES AS VALUE CONTAIN REPETITION OF 3 AT ONCE</P><P>Would appreciate your help on the above query</P><P>Shumail</P><P></P><P></P></BODY></HTML> Sun, 16 Jan 2011 09:47:16 GMT https://community.qlik.com/t5/QlikView/Number-repetition-in-the-value/m-p/300091#M1198609 shumailh 2011-01-16T09:47:16Z Number repetition in the value https://community.qlik.com/t5/QlikView/Number-repetition-in-the-value/m-p/300092#M1198610 <HTML><HEAD></HEAD><BODY><P>hei</P><P>attch is example of what you asked for</P><P>i am using two function:</P><P>1.SubStringcount- Counting how many time a substring appears in a string</P><P>2.wildmatch</P><P>hopes its helps you</P></BODY></HTML> Sun, 16 Jan 2011 12:21:08 GMT https://community.qlik.com/t5/QlikView/Number-repetition-in-the-value/m-p/300092#M1198610 lironbaram 2011-01-16T12:21:08Z Number repetition in the value https://community.qlik.com/t5/QlikView/Number-repetition-in-the-value/m-p/300093#M1198611 <HTML><HEAD></HEAD><BODY><P>Thanks Roi appreciate ur help</P></BODY></HTML> Mon, 17 Jan 2011 13:27:55 GMT https://community.qlik.com/t5/QlikView/Number-repetition-in-the-value/m-p/300093#M1198611 shumailh 2011-01-17T13:27:55Z