topic Re: set analysis with data containing operators as text in QlikView https://community.qlik.com/t5/QlikView/set-analysis-with-data-containing-operators-as-text/m-p/1234806#M517206 <HTML><HEAD></HEAD><BODY><P>What if you try this:</P><P></P><P><SPAN lang="EN-US"><STRONG>=C</STRONG></SPAN><STRONG><SPAN lang="EN-US">ount</SPAN><SPAN lang="EN-US">({$&lt;</SPAN><SPAN lang="EN-US">Field</SPAN><SPAN lang="EN-US">={"<SPAN style="color: #ff0000;"> =<STRONG style="font-size: 13.3333px;"><SPAN lang="EN-US">Field </SPAN></STRONG>= '*'</SPAN> "</SPAN><SPAN lang="EN-US">}&gt;</SPAN><SPAN lang="EN-US">Field</SPAN></STRONG><SPAN lang="EN-US"><STRONG>)</STRONG></SPAN></P></BODY></HTML> Wed, 25 Jan 2017 12:59:22 GMT sunny_talwar 2017-01-25T12:59:22Z set analysis with data containing operators as text https://community.qlik.com/t5/QlikView/set-analysis-with-data-containing-operators-as-text/m-p/1234805#M517205 <HTML><HEAD></HEAD><BODY><P>I have some<BR />data with the character “*” and “/”. These characters are mean as characters, not as operators.</P><P>If I use the set analysis function</P><P><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">=</SPAN><SPAN lang="EN-US" style="color: blue; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">count</SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">({$&lt;</SPAN><SPAN lang="EN-US" style="color: maroon; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">Field</SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">={“</SPAN><SPAN lang="EN-US" style="color: maroon; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">*”</SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">}&gt;</SPAN><SPAN lang="EN-US" style="color: maroon; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">Field</SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">) </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;"></SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">the count is done over all data.</SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Courier New'; font-size: 9pt; mso-ansi-language: EN-US;">What can I do to count only the fields containing the character “*”?</SPAN></P></BODY></HTML> Wed, 25 Jan 2017 12:56:41 GMT https://community.qlik.com/t5/QlikView/set-analysis-with-data-containing-operators-as-text/m-p/1234805#M517205 khag_hs 2017-01-25T12:56:41Z Re: set analysis with data containing operators as text https://community.qlik.com/t5/QlikView/set-analysis-with-data-containing-operators-as-text/m-p/1234806#M517206 <HTML><HEAD></HEAD><BODY><P>What if you try this:</P><P></P><P><SPAN lang="EN-US"><STRONG>=C</STRONG></SPAN><STRONG><SPAN lang="EN-US">ount</SPAN><SPAN lang="EN-US">({$&lt;</SPAN><SPAN lang="EN-US">Field</SPAN><SPAN lang="EN-US">={"<SPAN style="color: #ff0000;"> =<STRONG style="font-size: 13.3333px;"><SPAN lang="EN-US">Field </SPAN></STRONG>= '*'</SPAN> "</SPAN><SPAN lang="EN-US">}&gt;</SPAN><SPAN lang="EN-US">Field</SPAN></STRONG><SPAN lang="EN-US"><STRONG>)</STRONG></SPAN></P></BODY></HTML> Wed, 25 Jan 2017 12:59:22 GMT https://community.qlik.com/t5/QlikView/set-analysis-with-data-containing-operators-as-text/m-p/1234806#M517206 sunny_talwar 2017-01-25T12:59:22Z Re: set analysis with data containing operators as text https://community.qlik.com/t5/QlikView/set-analysis-with-data-containing-operators-as-text/m-p/1234807#M517207 <HTML><HEAD></HEAD><BODY><P>thank you, it works</P></BODY></HTML> Wed, 25 Jan 2017 13:17:37 GMT https://community.qlik.com/t5/QlikView/set-analysis-with-data-containing-operators-as-text/m-p/1234807#M517207 khag_hs 2017-01-25T13:17:37Z