topic Re: Summarize values in list in QlikView https://community.qlik.com/t5/QlikView/Summarize-values-in-list/m-p/492274#M483679 <HTML><HEAD></HEAD><BODY><P>Look at the function "RANK" it solves your problem and you can use it as expression in a list box </P><P></P><P>Hope it heklps</P></BODY></HTML> Thu, 20 Jun 2013 09:51:57 GMT alexandros17 2013-06-20T09:51:57Z Summarize values in list https://community.qlik.com/t5/QlikView/Summarize-values-in-list/m-p/492273#M483678 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is there a way to quickly select Customers with a total amount between 25000 and 50000, where Total amount is something like "sum(Ordervalue)"?</P><P></P><P>Is there a way to create Ranges and put these ranges in a List where People can select them, say:</P><P></P><P>A &gt; 50000<BR />B &gt; 25000<BR />C &gt; 10000<BR />D &lt;= 10000</P><P></P><P>Thanks in advance!</P></BODY></HTML> Thu, 20 Jun 2013 09:49:43 GMT https://community.qlik.com/t5/QlikView/Summarize-values-in-list/m-p/492273#M483678 fred_s 2013-06-20T09:49:43Z Re: Summarize values in list https://community.qlik.com/t5/QlikView/Summarize-values-in-list/m-p/492274#M483679 <HTML><HEAD></HEAD><BODY><P>Look at the function "RANK" it solves your problem and you can use it as expression in a list box </P><P></P><P>Hope it heklps</P></BODY></HTML> Thu, 20 Jun 2013 09:51:57 GMT https://community.qlik.com/t5/QlikView/Summarize-values-in-list/m-p/492274#M483679 alexandros17 2013-06-20T09:51:57Z