topic Re: Limit the value... in QlikView https://community.qlik.com/t5/QlikView/Limit-the-value/m-p/1135532#M909046 <HTML><HEAD></HEAD><BODY><P>Sample attached</P></BODY></HTML> Thu, 16 Jun 2016 19:03:22 GMT sunny_talwar 2016-06-16T19:03:22Z Limit the value... https://community.qlik.com/t5/QlikView/Limit-the-value/m-p/1135530#M909044 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Below is my sample data .</P><P></P><P>Region&nbsp;&nbsp;&nbsp;&nbsp; Cost</P><P>NA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100000</P><P>LATAM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90000</P><P>EMEA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60000</P><P>APAC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40000</P><P></P><P></P><P>I want to display cost by Region in bar chart but should have an option to toggle between regions with cost more than 75 k and regions with cost less than 75 k.</P><P></P><P>Is this doable at all ?</P><P></P><P>Thanks much.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Limit-the-value/m-p/1135530#M909044 2020-11-25T16:16:04Z Re: Limit the value... https://community.qlik.com/t5/QlikView/Limit-the-value/m-p/1135531#M909045 <HTML><HEAD></HEAD><BODY><P>Sure thing. May be using a variable called vVar, create an expression like this:</P><P></P><P><STRONG>If(vVar = 1, Sum(Cost), If(Sum(Cost) &gt; 75000, Sum(Cost)))</STRONG></P></BODY></HTML> Thu, 16 Jun 2016 19:01:20 GMT https://community.qlik.com/t5/QlikView/Limit-the-value/m-p/1135531#M909045 sunny_talwar 2016-06-16T19:01:20Z Re: Limit the value... https://community.qlik.com/t5/QlikView/Limit-the-value/m-p/1135532#M909046 <HTML><HEAD></HEAD><BODY><P>Sample attached</P></BODY></HTML> Thu, 16 Jun 2016 19:03:22 GMT https://community.qlik.com/t5/QlikView/Limit-the-value/m-p/1135532#M909046 sunny_talwar 2016-06-16T19:03:22Z