topic Re: If statement with Min function in QlikView https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1761356#M718541 <P>I'm creating dimension in a chart</P> Thu, 12 Nov 2020 22:19:23 GMT younlim91 2020-11-12T22:19:23Z If statement with Min function https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1760949#M718536 <P>Hello,<BR /><BR />I'm trying to create a dimension like "if ((min(A,B)-C) &gt; D, "N", "Y")". Please help! Thanks!!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="younlim91_0-1605146302943.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/44058iBDCAC3F4C7F6C19F/image-size/medium?v=v2&amp;px=400" role="button" title="younlim91_0-1605146302943.png" alt="younlim91_0-1605146302943.png" /></span></P><P>&nbsp;</P> Fri, 20 Nov 2020 18:58:42 GMT https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1760949#M718536 younlim91 2020-11-20T18:58:42Z Re: If statement with Min function https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1760951#M718537 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/129246">@younlim91</a>&nbsp;</P><P>Try like this</P><P>=if(RangeMin(A,B)-C &gt; D, "N", "Y")</P> Thu, 12 Nov 2020 02:24:07 GMT https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1760951#M718537 MayilVahanan 2020-11-12T02:24:07Z Re: If statement with Min function https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1761012#M718538 <P>It's giving me "Error in Expression"&nbsp;</P> Thu, 12 Nov 2020 08:17:41 GMT https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1761012#M718538 younlim91 2020-11-12T08:17:41Z Re: If statement with Min function https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1761013#M718539 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/129246">@younlim91</a>&nbsp;</P><P>Try with single quotes, like:</P><P><SPAN>=if(RangeMin(A,B)-C &gt; D, 'N', 'Y')</SPAN></P> Thu, 12 Nov 2020 08:27:47 GMT https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1761013#M718539 tresB 2020-11-12T08:27:47Z Re: If statement with Min function https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1761263#M718540 <P>are you creating the dimension in a chart or in the data model?</P> Thu, 12 Nov 2020 17:00:53 GMT https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1761263#M718540 edwin 2020-11-12T17:00:53Z Re: If statement with Min function https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1761356#M718541 <P>I'm creating dimension in a chart</P> Thu, 12 Nov 2020 22:19:23 GMT https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1761356#M718541 younlim91 2020-11-12T22:19:23Z Re: If statement with Min function https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1761362#M718542 <P>It works! thank you so much!</P> Thu, 12 Nov 2020 22:41:44 GMT https://community.qlik.com/t5/QlikView/If-statement-with-Min-function/m-p/1761362#M718542 younlim91 2020-11-12T22:41:44Z