topic Joker problem in QlikView https://community.qlik.com/t5/QlikView/Joker-problem/m-p/870522#M656363 <HTML><HEAD></HEAD><BODY><P><BR />I got at simular problem like Sørens Schou, in my case I have digit on both side of the wanted digit.</P><P>it look like this:</P><P>0100<SPAN style="color: #ff0000;">1713501040</SPAN>15 - i want to count the red marked digit.&nbsp; = ****<SPAN style="color: #ff0000;">1713501040</SPAN>**</P><P></P><P>How do I do it? Not like below or is it something in that direction........</P><P> </P><P><SPAN style="font-size: 8pt;"> count ({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">AAR</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(vPreviousYear)</EM></STRONG><SPAN style="font-size: 8pt;">},item1</SPAN><SPAN style="font-size: 8pt;">={'0100<SPAN style="color: #ff0000;">1713501040</SPAN>15'}&gt;}item2</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Best regards&nbsp;&nbsp; </SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Jesper</SPAN></P><P></P></BODY></HTML> Thu, 11 Jun 2015 08:24:48 GMT 2015-06-11T08:24:48Z Joker problem https://community.qlik.com/t5/QlikView/Joker-problem/m-p/870522#M656363 <HTML><HEAD></HEAD><BODY><P><BR />I got at simular problem like Sørens Schou, in my case I have digit on both side of the wanted digit.</P><P>it look like this:</P><P>0100<SPAN style="color: #ff0000;">1713501040</SPAN>15 - i want to count the red marked digit.&nbsp; = ****<SPAN style="color: #ff0000;">1713501040</SPAN>**</P><P></P><P>How do I do it? Not like below or is it something in that direction........</P><P> </P><P><SPAN style="font-size: 8pt;"> count ({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">AAR</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(vPreviousYear)</EM></STRONG><SPAN style="font-size: 8pt;">},item1</SPAN><SPAN style="font-size: 8pt;">={'0100<SPAN style="color: #ff0000;">1713501040</SPAN>15'}&gt;}item2</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Best regards&nbsp;&nbsp; </SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Jesper</SPAN></P><P></P></BODY></HTML> Thu, 11 Jun 2015 08:24:48 GMT https://community.qlik.com/t5/QlikView/Joker-problem/m-p/870522#M656363 2015-06-11T08:24:48Z