topic Re: set expression help. Select where less than variable in QlikView https://community.qlik.com/t5/QlikView/set-expression-help-Select-where-less-than-variable/m-p/413515#M485190 <HTML><HEAD></HEAD><BODY><P>You are a QV Wizard, thank you.</P></BODY></HTML> Tue, 30 Apr 2013 11:40:31 GMT 2013-04-30T11:40:31Z set expression help. Select where less than variable https://community.qlik.com/t5/QlikView/set-expression-help-Select-where-less-than-variable/m-p/413513#M485188 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P></P><P>This is what I have so far.</P><P>Sum({$&lt;d_DistanceApart_Miles={"&gt;=0&lt;varMaxDist"}&gt;}cen_Class_Data)</P><P></P><P></P><P>I am trying to sum the field cen_Class_Data</P><P>WHERE d_DistanceApart_Miles is LESS THAN varMaxDist (Which is a variable I have set)</P><P></P><P>Any clues why my set expression isn't working? It doesn't seem to be updating when I change my variable.</P></BODY></HTML> Tue, 30 Apr 2013 11:27:07 GMT https://community.qlik.com/t5/QlikView/set-expression-help-Select-where-less-than-variable/m-p/413513#M485188 2013-04-30T11:27:07Z Re: set expression help. Select where less than variable https://community.qlik.com/t5/QlikView/set-expression-help-Select-where-less-than-variable/m-p/413514#M485189 <HTML><HEAD></HEAD><BODY><P>try this</P><P><STRONG>Sum({$&lt;d_DistanceApart_Miles={"&gt;=0&lt;$(=varMaxDist)"}&gt;}cen_Class_Data)</STRONG></P></BODY></HTML> Tue, 30 Apr 2013 11:36:24 GMT https://community.qlik.com/t5/QlikView/set-expression-help-Select-where-less-than-variable/m-p/413514#M485189 2013-04-30T11:36:24Z Re: set expression help. Select where less than variable https://community.qlik.com/t5/QlikView/set-expression-help-Select-where-less-than-variable/m-p/413515#M485190 <HTML><HEAD></HEAD><BODY><P>You are a QV Wizard, thank you.</P></BODY></HTML> Tue, 30 Apr 2013 11:40:31 GMT https://community.qlik.com/t5/QlikView/set-expression-help-Select-where-less-than-variable/m-p/413515#M485190 2013-04-30T11:40:31Z