topic Re: problem with set analysis in QlikView https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399502#M812355 <HTML><HEAD></HEAD><BODY><P>i tried both single and double quotes but none of them work</P></BODY></HTML> Fri, 22 Sep 2017 14:53:42 GMT Anonymous 2017-09-22T14:53:42Z problem with set analysis https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399497#M812350 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I have problem with set analysis</P><P>I wanna count numbers equal to -1 in field success</P><P>I write this set expression that this site <A href="http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=" title="http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=" target="_blank">Set Analysis Wizard for QlikView | qlikblog.at</A> create for me but it doesn't work:</P><P>Count({$&lt;success={-1}&gt;}success)</P><P></P><P>this is my field's data:</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177467_Untitled.png" style="height: auto;" /></P><P>I would appreciate if anyone can help</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399497#M812350 Anonymous 2020-11-25T16:16:04Z Re: problem with set analysis https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399498#M812351 <HTML><HEAD></HEAD><BODY><P>Why don't you try this</P><P><STRONG>-Sum(Success)</STRONG></P></BODY></HTML> Fri, 22 Sep 2017 14:26:27 GMT https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399498#M812351 sunny_talwar 2017-09-22T14:26:27Z Re: problem with set analysis https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399499#M812352 <HTML><HEAD></HEAD><BODY><P>Or this</P><P></P><P><STRONG>Sum(-Success)</STRONG></P></BODY></HTML> Fri, 22 Sep 2017 14:26:44 GMT https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399499#M812352 sunny_talwar 2017-09-22T14:26:44Z Re: problem with set analysis https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399500#M812353 <HTML><HEAD></HEAD><BODY><P>Possibly Fabs( Sum( Success ) )...</P><P></P><P>Fabs = Absolute Value</P></BODY></HTML> Fri, 22 Sep 2017 14:37:08 GMT https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399500#M812353 oscar_ortiz 2017-09-22T14:37:08Z Re: problem with set analysis https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399501#M812354 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>you must write it this way :<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Count({$&lt;success={<STRONG>'</STRONG>-1<STRONG>'</STRONG>}&gt;}success) (between single quotes)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">the set interprets the minus as operator</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Hope it helps,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Andrei<BR /></SPAN></P></BODY></HTML> Fri, 22 Sep 2017 14:46:59 GMT https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399501#M812354 andrei_delta 2017-09-22T14:46:59Z Re: problem with set analysis https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399502#M812355 <HTML><HEAD></HEAD><BODY><P>i tried both single and double quotes but none of them work</P></BODY></HTML> Fri, 22 Sep 2017 14:53:42 GMT https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399502#M812355 Anonymous 2017-09-22T14:53:42Z Re: problem with set analysis https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399503#M812356 <HTML><HEAD></HEAD><BODY><P>thank's it's work finally but i want to know why set analysis didn't work</P></BODY></HTML> Fri, 22 Sep 2017 14:54:48 GMT https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399503#M812356 Anonymous 2017-09-22T14:54:48Z Re: problem with set analysis https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399504#M812357 <HTML><HEAD></HEAD><BODY><P>Your field name seems to be Success with a capital S, did you use this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Count({$&lt;success={-1}&gt;}success)</STRONG></SPAN></P><P></P><P>or this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Count({$&lt;Success={-1}&gt;}Success)</STRONG></SPAN></P><P></P><P>In QlikView, Success is different from success</P></BODY></HTML> Fri, 22 Sep 2017 15:00:23 GMT https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399504#M812357 sunny_talwar 2017-09-22T15:00:23Z Re: problem with set analysis https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399505#M812358 <HTML><HEAD></HEAD><BODY><P>I've used Count( {&lt; Success={"-1"} &gt;} Success) and it worked for me.&nbsp; Like <A href="https://community.qlik.com/qlik-users/249566">andrei.delta</A>‌ mentioned.</P><P></P><P><IMG alt="275594.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177466_275594.PNG" style="height: auto;" /></P><P></P><P>Good luck</P><P>Oscar</P></BODY></HTML> Fri, 22 Sep 2017 15:10:13 GMT https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399505#M812358 oscar_ortiz 2017-09-22T15:10:13Z Re: problem with set analysis https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399506#M812359 <HTML><HEAD></HEAD><BODY><P>wow i didn't notice that</P><P>thanks a lot <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 22 Sep 2017 15:11:33 GMT https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399506#M812359 Anonymous 2017-09-22T15:11:33Z Re: problem with set analysis https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399507#M812360 <HTML><HEAD></HEAD><BODY><P>So, then casing was the issue here?</P></BODY></HTML> Fri, 22 Sep 2017 15:14:41 GMT https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399507#M812360 sunny_talwar 2017-09-22T15:14:41Z Re: problem with set analysis https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399508#M812361 <HTML><HEAD></HEAD><BODY><P>thanks for your kindness Oscar, i didn't know that field name in qlik is case sensitive </P><P>i wrote it wrongly </P><P>thanks anyway to you<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 25 Sep 2017 05:05:18 GMT https://community.qlik.com/t5/QlikView/problem-with-set-analysis/m-p/1399508#M812361 Anonymous 2017-09-25T05:05:18Z