topic Re: variable - set in QlikView https://community.qlik.com/t5/QlikView/variable-set/m-p/1319240#M515174 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum({&lt;FieldName = {'$(=vSearch)'}&gt;}Sales)</STRONG></P></BODY></HTML> Tue, 23 May 2017 12:02:28 GMT sunny_talwar 2017-05-23T12:02:28Z variable - set https://community.qlik.com/t5/QlikView/variable-set/m-p/1319239#M515173 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>Please give me format for below variable in set</P><P></P><P>vSearch = &lt;3000 (I am entering in inputbox)</P><P></P><P>now I have to include above variable in sum(sales)</P><P></P><P></P><P></P><P>-Priya</P></BODY></HTML> Tue, 23 May 2017 11:56:52 GMT https://community.qlik.com/t5/QlikView/variable-set/m-p/1319239#M515173 priyarane 2017-05-23T11:56:52Z Re: variable - set https://community.qlik.com/t5/QlikView/variable-set/m-p/1319240#M515174 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum({&lt;FieldName = {'$(=vSearch)'}&gt;}Sales)</STRONG></P></BODY></HTML> Tue, 23 May 2017 12:02:28 GMT https://community.qlik.com/t5/QlikView/variable-set/m-p/1319240#M515174 sunny_talwar 2017-05-23T12:02:28Z Re: variable - set https://community.qlik.com/t5/QlikView/variable-set/m-p/1319241#M515175 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Do you want to compare the each Sales value against the vSearch and only that value should be considered for expression then try below script.</P><P></P><P>Sum{&lt;Sales ={"&gt;=$(vSearch)"}&gt;}Sales)</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Tue, 23 May 2017 12:02:36 GMT https://community.qlik.com/t5/QlikView/variable-set/m-p/1319241#M515175 kaushiknsolanki 2017-05-23T12:02:36Z