topic Re: expression including selected values in QlikView https://community.qlik.com/t5/QlikView/expression-including-selected-values/m-p/532372#M1141899 <HTML><HEAD></HEAD><BODY><P>Try: sum([$(=only(<EM>FieldnameOfYourListboxHere</EM>))])</P></BODY></HTML> Mon, 26 Aug 2013 17:03:18 GMT Gysbert_Wassenaar 2013-08-26T17:03:18Z expression including selected values https://community.qlik.com/t5/QlikView/expression-including-selected-values/m-p/532371#M1141898 <HTML><HEAD></HEAD><BODY><P>i have a scenario where i want to do an expression based on a selected value. the user will select&nbsp; zar or gbp in a list box. based on the selection the expression must sum (gbp value) when the user select gbp and sum(zar) when the user select zar. can someone please help me with an expression?</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/expression-including-selected-values/m-p/532371#M1141898 2020-11-20T18:02:30Z Re: expression including selected values https://community.qlik.com/t5/QlikView/expression-including-selected-values/m-p/532372#M1141899 <HTML><HEAD></HEAD><BODY><P>Try: sum([$(=only(<EM>FieldnameOfYourListboxHere</EM>))])</P></BODY></HTML> Mon, 26 Aug 2013 17:03:18 GMT https://community.qlik.com/t5/QlikView/expression-including-selected-values/m-p/532372#M1141899 Gysbert_Wassenaar 2013-08-26T17:03:18Z Re: expression including selected values https://community.qlik.com/t5/QlikView/expression-including-selected-values/m-p/532373#M1141900 <HTML><HEAD></HEAD><BODY><P>Make a list box with two values zar and gbp.&nbsp; Then create the two expressions, using conditional statements make a statement that uses the Sum(zar) when the value of the listbox = zar and Sum(gbp) when the value of the list box = gbp.</P><P></P><P>You could make a field with an inline table with the values zar and gbp and then put that field in a list box. </P><P></P><P>GetFieldSelections(NameOFField) = 'zar' as the conditional (as an example)</P></BODY></HTML> Mon, 26 Aug 2013 17:57:01 GMT https://community.qlik.com/t5/QlikView/expression-including-selected-values/m-p/532373#M1141900 jpapador 2013-08-26T17:57:01Z