topic pls check the expression for range in QlikView https://community.qlik.com/t5/QlikView/pls-check-the-expression-for-range/m-p/243456#M500155 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>the brackets {} are only used in set analysis together with aggregation: sum, or Avg, etc. You need only if-then-else like this:</P><P></P><P>If(bc&gt;=$(bcVar1) And bc&lt;=$(bcVar2),'Pass','Fail')</P></BODY></HTML> Thu, 26 May 2011 16:11:59 GMT brenner_martina 2011-05-26T16:11:59Z pls check the expression for range https://community.qlik.com/t5/QlikView/pls-check-the-expression-for-range/m-p/243455#M500154 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone check this expression and say me where i had done mistake in&nbsp; this.</P><P></P><P>=if(GetCurrentField(bc)={"&gt;=$(bcVar1)&lt;=$(bcVar2)"} ,'Pass', 'Fail')</P><P></P><P>I am having a barchart along with slider, the above expression variable are min and max of the slider position.&nbsp;&nbsp;&nbsp; Which is inrange that should get "Pass"&nbsp; otherwise "Fail"</P><P></P><P>Actual requirement is, in my file having a straight table with 3 columns</P><P></P><P>one is group i.e; BC ,</P><P>second is Count,</P><P>third is Status.</P><P></P><P>EX: "It should look like this"</P><P></P><P>BC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Count&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status</P><P>0.16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pass</P><P>0.17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pass</P><P>0.17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pass</P><P>0.18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fail</P><P>0.18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fail</P><P></P><P>I am using this expression in third column.</P><P></P><P>Thnks in advance..</P></BODY></HTML> Thu, 26 May 2011 13:07:08 GMT https://community.qlik.com/t5/QlikView/pls-check-the-expression-for-range/m-p/243455#M500154 2011-05-26T13:07:08Z pls check the expression for range https://community.qlik.com/t5/QlikView/pls-check-the-expression-for-range/m-p/243456#M500155 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>the brackets {} are only used in set analysis together with aggregation: sum, or Avg, etc. You need only if-then-else like this:</P><P></P><P>If(bc&gt;=$(bcVar1) And bc&lt;=$(bcVar2),'Pass','Fail')</P></BODY></HTML> Thu, 26 May 2011 16:11:59 GMT https://community.qlik.com/t5/QlikView/pls-check-the-expression-for-range/m-p/243456#M500155 brenner_martina 2011-05-26T16:11:59Z