topic Re: Help with QlikView Formula in QlikView https://community.qlik.com/t5/QlikView/Help-with-QlikView-Formula/m-p/1221700#M390553 <HTML><HEAD></HEAD><BODY><P>If you have limited string, you can write an expression for each string:</P><P>=count({&lt;ColB={'*string1*'}&gt;} 1) </P></BODY></HTML> Mon, 06 Feb 2017 16:05:46 GMT Anonymous 2017-02-06T16:05:46Z Help with QlikView Formula https://community.qlik.com/t5/QlikView/Help-with-QlikView-Formula/m-p/1221698#M390551 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>I am having a hard time trying to implement a formula inside QlikView...</P><P></P><P>Can I ask for some help?</P><P></P><P>My data looks like this:&nbsp;&nbsp; </P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ColA</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ColB - list of values concatenated by ;</STRONG></TH></TR><TR><TD style="padding: 2px;">id1</TD><TD style="padding: 2px;">string1;string2;string3;string4</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">id2</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">string1;string4</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">id3</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">string3;string4</SPAN></TD></TR></TBODY></TABLE><P></P><P>I need to count the total number of times a "string" in ColB appears depending on the selection of ColA.</P><P></P><P>For example, if all "ids" in ColA are selected, the result would be:</P><P></P><P>string1 : 2 times</P><P><SPAN style="font-size: 13.3333330154419px;">string2 : 1 time</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">string3 : 2 times</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">string4 : 3 times</SPAN></P><P></P><P>Any ideas?</P></BODY></HTML> Mon, 06 Feb 2017 15:58:17 GMT https://community.qlik.com/t5/QlikView/Help-with-QlikView-Formula/m-p/1221698#M390551 2017-02-06T15:58:17Z Re: Help with QlikView Formula https://community.qlik.com/t5/QlikView/Help-with-QlikView-Formula/m-p/1221699#M390552 <HTML><HEAD></HEAD><BODY><P>May be like this...</P><P></P><P>Script</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD * INLINE [</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ColA, ColB</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; id1, string1;string2;string3;string4</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; id2, string1;string4</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; id3, string3;string4</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><STRONG>LinkTable:</STRONG></P><P><STRONG>LOAD Distinct ColB,</STRONG></P><P><STRONG>&nbsp; SubField(ColB, ';') as List</STRONG></P><P><STRONG>Resident Table;</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/152179_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 06 Feb 2017 16:02:19 GMT https://community.qlik.com/t5/QlikView/Help-with-QlikView-Formula/m-p/1221699#M390552 sunny_talwar 2017-02-06T16:02:19Z Re: Help with QlikView Formula https://community.qlik.com/t5/QlikView/Help-with-QlikView-Formula/m-p/1221700#M390553 <HTML><HEAD></HEAD><BODY><P>If you have limited string, you can write an expression for each string:</P><P>=count({&lt;ColB={'*string1*'}&gt;} 1) </P></BODY></HTML> Mon, 06 Feb 2017 16:05:46 GMT https://community.qlik.com/t5/QlikView/Help-with-QlikView-Formula/m-p/1221700#M390553 Anonymous 2017-02-06T16:05:46Z Re: Help with QlikView Formula https://community.qlik.com/t5/QlikView/Help-with-QlikView-Formula/m-p/1221701#M390554 <HTML><HEAD></HEAD><BODY><P>Perfect Answer...&nbsp; !</P></BODY></HTML> Mon, 06 Feb 2017 17:14:10 GMT https://community.qlik.com/t5/QlikView/Help-with-QlikView-Formula/m-p/1221701#M390554 2017-02-06T17:14:10Z