topic Re: If condition not respected in QlikView https://community.qlik.com/t5/QlikView/If-condition-not-respected/m-p/696658#M1083077 <HTML><HEAD></HEAD><BODY><P>Try with</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt; line-height: 1.5em;">=Count(if(<STRONG>Trim(</STRONG> RaiserPlantID <STRONG>)</STRONG> = <STRONG>Trim(</STRONG> Responsible <STRONG>)</STRONG>, REA ) )</SPAN></P></BODY></HTML> Tue, 17 Jun 2014 15:39:54 GMT its_anandrjs 2014-06-17T15:39:54Z If condition not respected https://community.qlik.com/t5/QlikView/If-condition-not-respected/m-p/696657#M1083076 <HTML><HEAD></HEAD><BODY><P>Why my if condition it's not respect for some values.</P><P>My condition:</P><P>=Count(if(RaiserPlantID = Responsible, REA,))</P><P></P><P>I've 349 when i only should have 347.</P><P></P><P>At the moment what is selected:</P><P>RaiserPlant = 351E</P><P></P><P>Why this 2 are showed if raiserPlantID is different from Responsible as you can see in the pic</P><P><IMG alt="Untitled.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/60739_Untitled.png" style="width: 620px; height: 284px;" /></P></BODY></HTML> Tue, 17 Jun 2014 14:59:12 GMT https://community.qlik.com/t5/QlikView/If-condition-not-respected/m-p/696657#M1083076 2014-06-17T14:59:12Z Re: If condition not respected https://community.qlik.com/t5/QlikView/If-condition-not-respected/m-p/696658#M1083077 <HTML><HEAD></HEAD><BODY><P>Try with</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt; line-height: 1.5em;">=Count(if(<STRONG>Trim(</STRONG> RaiserPlantID <STRONG>)</STRONG> = <STRONG>Trim(</STRONG> Responsible <STRONG>)</STRONG>, REA ) )</SPAN></P></BODY></HTML> Tue, 17 Jun 2014 15:39:54 GMT https://community.qlik.com/t5/QlikView/If-condition-not-respected/m-p/696658#M1083077 its_anandrjs 2014-06-17T15:39:54Z Re: If condition not respected https://community.qlik.com/t5/QlikView/If-condition-not-respected/m-p/696659#M1083078 <HTML><HEAD></HEAD><BODY><P>or try with:</P><P></P><P>count({&lt;RaiserplantID = {$(=Trim(Only(Responsable)))}&gt;} REA)</P><P></P><P>best regards.</P></BODY></HTML> Tue, 17 Jun 2014 15:57:37 GMT https://community.qlik.com/t5/QlikView/If-condition-not-respected/m-p/696659#M1083078 2014-06-17T15:57:37Z Re: If condition not respected https://community.qlik.com/t5/QlikView/If-condition-not-respected/m-p/696660#M1083080 <HTML><HEAD></HEAD><BODY><P>You save my day, thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /> i hope some day i can retribute</P></BODY></HTML> Wed, 18 Jun 2014 09:14:03 GMT https://community.qlik.com/t5/QlikView/If-condition-not-respected/m-p/696660#M1083080 2014-06-18T09:14:03Z