topic Re: set analysis in QlikView https://community.qlik.com/t5/QlikView/set-analysis/m-p/403595#M1272774 <HTML><HEAD></HEAD><BODY><P>Hey</P><P></P><P>Tks for your reply</P><P></P><P>Shfit is red underline and getting no result</P></BODY></HTML> Tue, 08 Jan 2013 16:03:25 GMT 2013-01-08T16:03:25Z set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/403593#M1272768 <HTML><HEAD></HEAD><BODY><P>hope someone can help me</P><P></P><P>have to create a pie chart with following expression :</P><P></P><P>Have following field names : </P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Shfit</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Contract</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Mch_code</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Work_Type_ID</STRONG></SPAN></TH></TR><TR><TD>S0</TD><TD>ANTWERP</TD><TD>NAT_TR</TD><TD>OPERLO</TD></TR><TR><TD>S1</TD><TD>BRUSSELS</TD><TD>NAT_WG</TD><TD>OPERLO</TD></TR><TR><TD>S1</TD><TD>ANTWERP</TD><TD>SH01234</TD><TD>OPERLA</TD></TR><TR><TD>S2</TD><TD>BRUSSELS</TD><TD>NAT_WG</TD><TD>OPERLA</TD></TR></TBODY></TABLE><P></P><P>Need to create a pie chart for only the items with Mch_code SH* and counting result SH01234 1 </P><P></P><P>Need to create a pie chart for only the items with Mch_code NAT* and counting result NAT_TR 1 &amp; NAT_WG 2</P><P></P><P>Can someone help me with creating the set analysis ?</P><P></P><P>Tks for yr help</P><P></P><P>Rudi</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/403593#M1272768 2026-01-26T18:19:17Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/403594#M1272770 <HTML><HEAD></HEAD><BODY><P>hello </P><P></P><P>try this one for the first one&nbsp; count({$&lt;Mch_code= {"<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">SH*</SPAN>"}&gt;}Shfit) and this for the second chart </P><P>count({$&lt;Mch_code= {"<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">NAT</SPAN>*"}&gt;}Shfit). and let me know</P></BODY></HTML> Tue, 08 Jan 2013 15:50:45 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/403594#M1272770 2013-01-08T15:50:45Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/403595#M1272774 <HTML><HEAD></HEAD><BODY><P>Hey</P><P></P><P>Tks for your reply</P><P></P><P>Shfit is red underline and getting no result</P></BODY></HTML> Tue, 08 Jan 2013 16:03:25 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/403595#M1272774 2013-01-08T16:03:25Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/403596#M1272779 <HTML><HEAD></HEAD><BODY><P>oke its working changed shfit into Std_job_id</P><P></P><P>Tks for yr help</P></BODY></HTML> Tue, 08 Jan 2013 16:07:19 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/403596#M1272779 2013-01-08T16:07:19Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/403597#M1272782 <HTML><HEAD></HEAD><BODY><P>great, happy to help!</P></BODY></HTML> Tue, 08 Jan 2013 16:10:28 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/403597#M1272782 2013-01-08T16:10:28Z