topic Re: Problem with array variables in QlikView https://community.qlik.com/t5/QlikView/Problem-with-array-variables/m-p/420445#M156475 <HTML><HEAD></HEAD><BODY><P>Maybe try something like this. See attached. </P></BODY></HTML> Wed, 19 Sep 2012 14:15:16 GMT 2012-09-19T14:15:16Z Problem with array variables https://community.qlik.com/t5/QlikView/Problem-with-array-variables/m-p/420444#M156474 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">Hi</SPAN> <SPAN class="hps">all</SPAN>,<BR /><BR /><SPAN class="hps">Well, I have</SPAN> <SPAN class="hps">a concern</SPAN> <SPAN class="hps">about</SPAN> <SPAN class="hps">a simple table</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">dimensions</SPAN> <SPAN class="hps">and expressions</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">"Weight"</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">"Diameter"</SPAN> <SPAN class="hps">and give the</SPAN> <SPAN class="hps">possibility to the user</SPAN> <SPAN class="hps">to enter their</SPAN> <SPAN class="hps">weight</SPAN> <SPAN class="hps">min and max</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">min and max</SPAN> <SPAN class="hps">diameter</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">that</SPAN> <SPAN class="hps">displays only</SPAN> <SPAN class="hps">lines</SPAN> <SPAN class="hps">validating</SPAN> <SPAN class="hps">both conditions.</SPAN><BR /><BR /><SPAN class="hps">So</SPAN> <SPAN class="hps">as an expression</SPAN> <SPAN class="hps">I</SPAN> <SPAN class="hps">set</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">following</SPAN> <SPAN class="hps">analysis</SPAN>:<BR /><SPAN class="hps">=</SPAN> <SPAN class="hps atn">only (</SPAN>{$ <SPAN class="hps">&lt;Diametre={"&gt;</SPAN> <SPAN class="hps atn">= $ (</SPAN>= <SPAN class="hps">vchoixmindiam</SPAN>) <SPAN class="hps">&lt;= $</SPAN> <SPAN class="hps">(=</SPAN> <SPAN class="hps">vchoixmaxdiam</SPAN><SPAN class="atn">) "</SPAN>}&gt;} <SPAN class="hps">Diameter)</SPAN><BR /><SPAN class="hps">=</SPAN> <SPAN class="hps atn">only (</SPAN>{$ <SPAN class="hps">&lt;Poids={"&gt;</SPAN> <SPAN class="hps atn">= $ (</SPAN>= <SPAN class="hps">vchoixminpoids</SPAN>) <SPAN class="hps">&lt;= $</SPAN> <SPAN class="hps">(=</SPAN> <SPAN class="hps">vchoixmaxpoids</SPAN><SPAN class="atn">) "</SPAN>}&gt;} <SPAN class="hps">Weight)</SPAN><BR /><BR /><SPAN class="hps">But I</SPAN> <SPAN class="hps">can not</SPAN> <SPAN class="hps">not display</SPAN> <SPAN class="hps">lines that do</SPAN> <SPAN class="hps">not match the</SPAN> <SPAN class="hps atn">selection (</SPAN>see attached file) <SPAN class="hps">I would like</SPAN> <SPAN class="hps">if the weight</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">diameter</SPAN> <SPAN class="hps">are filled</SPAN> <SPAN class="hps">I want to see</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">two</SPAN> <SPAN class="hps">lines</SPAN> <SPAN class="hps">enabling</SPAN> <SPAN class="hps">condition,</SPAN> <SPAN class="hps">or if</SPAN> <SPAN class="hps">one</SPAN> <SPAN class="hps">(weight</SPAN> <SPAN class="hps">or</SPAN> <SPAN class="hps">diameter</SPAN>) <SPAN class="hps">is filled</SPAN> <SPAN class="hps">to see the lines</SPAN> <SPAN class="hps">validating the</SPAN> <SPAN class="hps">condition!</SPAN><BR /><BR /><SPAN class="hps">Do you have any</SPAN> <SPAN class="hps">ideas?</SPAN><BR /><SPAN class="hps">Thank you</SPAN> <SPAN class="hps">for your attention</SPAN><BR /><SPAN class="hps">Quentin</SPAN></SPAN> </P></BODY></HTML> Wed, 19 Sep 2012 08:09:01 GMT https://community.qlik.com/t5/QlikView/Problem-with-array-variables/m-p/420444#M156474 2012-09-19T08:09:01Z Re: Problem with array variables https://community.qlik.com/t5/QlikView/Problem-with-array-variables/m-p/420445#M156475 <HTML><HEAD></HEAD><BODY><P>Maybe try something like this. See attached. </P></BODY></HTML> Wed, 19 Sep 2012 14:15:16 GMT https://community.qlik.com/t5/QlikView/Problem-with-array-variables/m-p/420445#M156475 2012-09-19T14:15:16Z Re: Problem with array variables https://community.qlik.com/t5/QlikView/Problem-with-array-variables/m-p/420446#M156476 <HTML><HEAD></HEAD><BODY><P>Thank you Rebeccad,</P><P>it was exactly the answer of my problem and thank you for your attached and your times!</P><P>Have a good day</P></BODY></HTML> Thu, 20 Sep 2012 08:45:43 GMT https://community.qlik.com/t5/QlikView/Problem-with-array-variables/m-p/420446#M156476 2012-09-20T08:45:43Z