topic How to display nearest value in a dimension in QlikView https://community.qlik.com/t5/QlikView/How-to-display-nearest-value-in-a-dimension/m-p/788011#M533442 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to know if it's possible to display, as a bar chart dimension, the selected value (from a dimension list box) and the nearest values, such as the bigger two and the lower two, respect to a measure.</P><P></P><P>Example:</P><P>Dimension&nbsp;&nbsp;&nbsp; Measure</P><P>S1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>S2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P><P>S3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P>S4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>S5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11</P><P>S6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P><P>S7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>S8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>S9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P></P><P>So, if the user selects S1 the result will be a bar chart with, as dimension, the values:&nbsp; S7 S4 <STRONG>S1</STRONG> S2 S6 (in this order) and their Masures as the bars.</P><P>If user selects S5 the result will be a bar chart with, as dimension, the values:&nbsp; <STRONG>S5</STRONG> S1 S4.</P><P>If user selects S3 the result will be a bar chart with, as dimension, the values:&nbsp; S2 S6 <STRONG>S3</STRONG>.</P><P></P><P>Thanks in advance for your help!</P><P></P><P>Elena</P></BODY></HTML> Wed, 25 Mar 2015 11:08:38 GMT Anonymous 2015-03-25T11:08:38Z How to display nearest value in a dimension https://community.qlik.com/t5/QlikView/How-to-display-nearest-value-in-a-dimension/m-p/788011#M533442 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to know if it's possible to display, as a bar chart dimension, the selected value (from a dimension list box) and the nearest values, such as the bigger two and the lower two, respect to a measure.</P><P></P><P>Example:</P><P>Dimension&nbsp;&nbsp;&nbsp; Measure</P><P>S1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>S2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P><P>S3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P>S4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>S5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11</P><P>S6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P><P>S7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>S8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>S9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P></P><P>So, if the user selects S1 the result will be a bar chart with, as dimension, the values:&nbsp; S7 S4 <STRONG>S1</STRONG> S2 S6 (in this order) and their Masures as the bars.</P><P>If user selects S5 the result will be a bar chart with, as dimension, the values:&nbsp; <STRONG>S5</STRONG> S1 S4.</P><P>If user selects S3 the result will be a bar chart with, as dimension, the values:&nbsp; S2 S6 <STRONG>S3</STRONG>.</P><P></P><P>Thanks in advance for your help!</P><P></P><P>Elena</P></BODY></HTML> Wed, 25 Mar 2015 11:08:38 GMT https://community.qlik.com/t5/QlikView/How-to-display-nearest-value-in-a-dimension/m-p/788011#M533442 Anonymous 2015-03-25T11:08:38Z Re: How to display nearest value in a dimension https://community.qlik.com/t5/QlikView/How-to-display-nearest-value-in-a-dimension/m-p/788012#M533443 <HTML><HEAD></HEAD><BODY><P>Any ideas?</P><P></P><P>Thanks,</P><P>Elena</P></BODY></HTML> Thu, 26 Mar 2015 19:20:16 GMT https://community.qlik.com/t5/QlikView/How-to-display-nearest-value-in-a-dimension/m-p/788012#M533443 Anonymous 2015-03-26T19:20:16Z