topic Re: Selecting dimensions with average measure... in QlikView https://community.qlik.com/t5/QlikView/Selecting-dimensions-with-average-measure/m-p/1199642#M386506 <HTML><HEAD></HEAD><BODY><P>How will the filter look like? 2-3 or are you planning to get this as an input from users in a input box?</P></BODY></HTML> Fri, 28 Oct 2016 17:03:28 GMT sunny_talwar 2016-10-28T17:03:28Z Selecting dimensions with average measure... https://community.qlik.com/t5/QlikView/Selecting-dimensions-with-average-measure/m-p/1199641#M386505 <HTML><HEAD></HEAD><BODY><P>I have multiple measures by country and I would like to select any country with an average within a range.</P><P>For example, select all country's with an average "score" between 2 and 3.</P><P></P><P>What I get is a list of country's where any of the raw values is between 2 and 3.</P><P></P><TABLE border="1" class="jiveBorder" height="249" style="border: 1px solid #000000; width: 302px; height: 241px;" width="300"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Country</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Measure</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Value</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">X</TD><TD style="padding: 2px;">1</TD></TR><TR><TD>A</TD><TD>Y</TD><TD>2</TD></TR><TR><TD>A</TD><TD>Z</TD><TD>3</TD></TR><TR><TD>B</TD><TD>X</TD><TD>2</TD></TR><TR><TD>B</TD><TD>Y</TD><TD>4</TD></TR><TR><TD>B</TD><TD>Z</TD><TD>6</TD></TR><TR><TD>C</TD><TD>X</TD><TD>1</TD></TR><TR><TD>C</TD><TD>Y</TD><TD>1</TD></TR><TR><TD>C</TD><TD>Z</TD><TD>1</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 28 Oct 2016 14:40:03 GMT https://community.qlik.com/t5/QlikView/Selecting-dimensions-with-average-measure/m-p/1199641#M386505 markp201 2016-10-28T14:40:03Z Re: Selecting dimensions with average measure... https://community.qlik.com/t5/QlikView/Selecting-dimensions-with-average-measure/m-p/1199642#M386506 <HTML><HEAD></HEAD><BODY><P>How will the filter look like? 2-3 or are you planning to get this as an input from users in a input box?</P></BODY></HTML> Fri, 28 Oct 2016 17:03:28 GMT https://community.qlik.com/t5/QlikView/Selecting-dimensions-with-average-measure/m-p/1199642#M386506 sunny_talwar 2016-10-28T17:03:28Z Re: Selecting dimensions with average measure... https://community.qlik.com/t5/QlikView/Selecting-dimensions-with-average-measure/m-p/1199643#M386507 <HTML><HEAD></HEAD><BODY><P>I believe use this as your select expression?</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">=avg(Value)&gt;=2 and avg(Value)&lt;=3</SPAN></P></BODY></HTML> Fri, 28 Oct 2016 17:04:47 GMT https://community.qlik.com/t5/QlikView/Selecting-dimensions-with-average-measure/m-p/1199643#M386507 johnw 2016-10-28T17:04:47Z