topic Help with formula how to select proper value in QlikView https://community.qlik.com/t5/QlikView/Help-with-formula-how-to-select-proper-value/m-p/443408#M484532 <HTML><HEAD></HEAD><BODY><P>Value&nbsp;&nbsp; <STRONG> l_pdol1000</STRONG> is culculated in chart table1 and = 42; </P><P></P><P>I need to get value from<STRONG> per_comm</STRONG>&nbsp; field from different table2&nbsp;&nbsp;&nbsp; where my value&nbsp; l_pdol1000 </P><P></P><P>will be between from_per&nbsp; field and to_per&nbsp; field&nbsp;&nbsp;&nbsp;&nbsp; " from_per &lt;=l_pdol1000&nbsp; &gt;=to_per"</P><P></P><P></P><P> {&lt;from_per&lt;= l_pdol1000,to_per&lt;=l_pdol1000 &gt;}per_comm&nbsp;&nbsp;&nbsp; </P><P>Please Help with Formula.</P><P></P><P>Thank you</P><P><IMG alt="pic1.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/42220_pic1.JPG" width="450" /></P></BODY></HTML> Wed, 05 Jun 2013 17:50:51 GMT 2013-06-05T17:50:51Z Help with formula how to select proper value https://community.qlik.com/t5/QlikView/Help-with-formula-how-to-select-proper-value/m-p/443408#M484532 <HTML><HEAD></HEAD><BODY><P>Value&nbsp;&nbsp; <STRONG> l_pdol1000</STRONG> is culculated in chart table1 and = 42; </P><P></P><P>I need to get value from<STRONG> per_comm</STRONG>&nbsp; field from different table2&nbsp;&nbsp;&nbsp; where my value&nbsp; l_pdol1000 </P><P></P><P>will be between from_per&nbsp; field and to_per&nbsp; field&nbsp;&nbsp;&nbsp;&nbsp; " from_per &lt;=l_pdol1000&nbsp; &gt;=to_per"</P><P></P><P></P><P> {&lt;from_per&lt;= l_pdol1000,to_per&lt;=l_pdol1000 &gt;}per_comm&nbsp;&nbsp;&nbsp; </P><P>Please Help with Formula.</P><P></P><P>Thank you</P><P><IMG alt="pic1.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/42220_pic1.JPG" width="450" /></P></BODY></HTML> Wed, 05 Jun 2013 17:50:51 GMT https://community.qlik.com/t5/QlikView/Help-with-formula-how-to-select-proper-value/m-p/443408#M484532 2013-06-05T17:50:51Z