topic Re: minimum value if in QlikView https://community.qlik.com/t5/QlikView/minimum-value-if/m-p/1203146#M875082 <HTML><HEAD></HEAD><BODY><P>Maybe you can close the discussion</P></BODY></HTML> Wed, 02 Nov 2016 19:24:42 GMT rupamjyotidas 2016-11-02T19:24:42Z minimum value if https://community.qlik.com/t5/QlikView/minimum-value-if/m-p/1203143#M875077 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'd like to display only the information from the same record. Example below are different packages/ dimensions.</P><P>VPNART: the key (ProductID)</P><P>VPACEH: QTY in box</P><P>VPVUIT: 1 = we can handle/&nbsp; 0 we can't handle</P><P>... rest are dimensions/ weight</P><P></P><P>min.value VPACEH where VPVUIT = 1</P><P></P><P>Example of what I want to display with an expression:&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 576px;"><TBODY><TR><TD class="xl65" height="20" width="64"><SPAN style="color: #3366ff;">VPNART</SPAN></TD><TD class="xl65" width="64"><SPAN style="color: #3366ff;">VPACEH</SPAN></TD><TD class="xl65" width="64"><SPAN style="color: #3366ff;">STREEP</SPAN></TD><TD class="xl65" width="64"><SPAN style="color: #3366ff;">VPVINS</SPAN></TD><TD class="xl65" width="64"><SPAN style="color: #3366ff;">VPVUIT</SPAN></TD><TD class="xl65" width="64"><SPAN style="color: #3366ff;">VPHVRP</SPAN></TD><TD class="xl65" width="64"><SPAN style="color: #3366ff;">VPBVRP</SPAN></TD><TD class="xl65" width="64"><SPAN style="color: #3366ff;">VPDVRP</SPAN></TD><TD class="xl65" width="64"><SPAN style="color: #3366ff;">VPGVRP</SPAN></TD></TR><TR><TD class="xl65" height="20"><SPAN style="color: #3366ff;">011330</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">1</SPAN></TD><TD class="xl65"><SPAN style="color: #3366ff;">-1</SPAN></TD><TD class="xl65"><SPAN style="color: #3366ff;">0</SPAN></TD><TD class="xl65"><SPAN style="color: #3366ff;">1</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">11</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">207</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">312</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">523</SPAN></TD></TR><TR><TD class="xl65" height="20"><SPAN style="color: #3366ff;">011331</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">5</SPAN></TD><TD class="xl65"><SPAN style="color: #3366ff;">-3</SPAN></TD><TD class="xl65"><SPAN style="color: #3366ff;">1</SPAN></TD><TD class="xl65"><SPAN style="color: #3366ff;">1</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">47</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">154</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">211</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">1152</SPAN></TD></TR><TR><TD class="xl65" height="20"><SPAN style="color: #3366ff;">011332</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">1</SPAN></TD><TD class="xl65"><SPAN style="color: #3366ff;">-1</SPAN></TD><TD class="xl65"><SPAN style="color: #3366ff;">0</SPAN></TD><TD class="xl65"><SPAN style="color: #3366ff;">1</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">9</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">104</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">141</SPAN></TD><TD align="right"><SPAN style="color: #3366ff;">116</SPAN></TD></TR></TBODY></TABLE><P></P><P> INPUT </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 576px;"><TBODY><TR><TD class="xl63" height="20" width="64">VPNART</TD><TD class="xl63" width="64">VPACEH</TD><TD class="xl63" width="64">STREEP</TD><TD class="xl63" width="64">VPVINS</TD><TD class="xl63" width="64">VPVUIT</TD><TD class="xl63" width="64">VPHVRP</TD><TD class="xl63" width="64">VPBVRP</TD><TD class="xl63" width="64">VPDVRP</TD><TD class="xl63" width="64">VPGVRP</TD></TR><TR><TD class="xl63" height="20">011330</TD><TD align="right">1</TD><TD class="xl63">-1</TD><TD class="xl63">0</TD><TD class="xl63">1</TD><TD align="right">11</TD><TD align="right">207</TD><TD align="right">312</TD><TD align="right">523</TD></TR><TR><TD class="xl63" height="20">011330</TD><TD align="right">5</TD><TD class="xl63">-3</TD><TD class="xl63">1</TD><TD class="xl63">1</TD><TD align="right">54</TD><TD align="right">215</TD><TD align="right">319</TD><TD align="right">2908</TD></TR><TR><TD class="xl63" height="20">011330</TD><TD align="right">20</TD><TD class="xl63">-6</TD><TD class="xl63">1</TD><TD class="xl63">0</TD><TD align="right">60</TD><TD align="right">60</TD><TD align="right">60</TD><TD align="right">60</TD></TR><TR><TD class="xl63" height="20">011330</TD><TD align="right">1320</TD><TD class="xl63">-9</TD><TD class="xl63">1</TD><TD class="xl63">1</TD><TD align="right">1450</TD><TD align="right">800</TD><TD align="right">1200</TD><TD align="right">0</TD></TR><TR><TD class="xl63" height="20">011331</TD><TD align="right">1</TD><TD class="xl63">-1</TD><TD class="xl63">0</TD><TD class="xl63">0</TD><TD align="right">11</TD><TD align="right">149</TD><TD align="right">208</TD><TD align="right">231</TD></TR><TR><TD class="xl63" height="20">011331</TD><TD align="right">5</TD><TD class="xl63">-3</TD><TD class="xl63">1</TD><TD class="xl63">1</TD><TD align="right">47</TD><TD align="right">154</TD><TD align="right">211</TD><TD align="right">1152</TD></TR><TR><TD class="xl63" height="20">011332</TD><TD align="right">1</TD><TD class="xl63">-1</TD><TD class="xl63">0</TD><TD class="xl63">1</TD><TD align="right">9</TD><TD align="right">104</TD><TD align="right">141</TD><TD align="right">116</TD></TR><TR><TD class="xl63" height="20">011332</TD><TD align="right">10</TD><TD class="xl63">-3</TD><TD class="xl63">1</TD><TD class="xl63">1</TD><TD align="right">82</TD><TD align="right">112</TD><TD align="right">149</TD><TD align="right">1173</TD></TR></TBODY></TABLE><P></P><P>Which expression displays the information I want...?</P><P></P><P>Many thanks for your help.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/minimum-value-if/m-p/1203143#M875077 stevenpiers 2020-11-25T16:16:04Z Re: minimum value if https://community.qlik.com/t5/QlikView/minimum-value-if/m-p/1203144#M875080 <HTML><HEAD></HEAD><BODY><P>You can get it by using FirstSortedValue() like this:</P><P></P><P>FirstSortedValue({&lt;VPVUIT={1}&gt;}VPACEH,VPACEH)</P><P></P><P>Please see the attached example for a full solution.</P></BODY></HTML> Tue, 01 Nov 2016 16:26:28 GMT https://community.qlik.com/t5/QlikView/minimum-value-if/m-p/1203144#M875080 Nicole-Smith 2016-11-01T16:26:28Z Re: minimum value if https://community.qlik.com/t5/QlikView/minimum-value-if/m-p/1203145#M875081 <HTML><HEAD></HEAD><BODY><P>Just... perfect! Thanks Nicole! </P></BODY></HTML> Wed, 02 Nov 2016 07:25:37 GMT https://community.qlik.com/t5/QlikView/minimum-value-if/m-p/1203145#M875081 stevenpiers 2016-11-02T07:25:37Z Re: minimum value if https://community.qlik.com/t5/QlikView/minimum-value-if/m-p/1203146#M875082 <HTML><HEAD></HEAD><BODY><P>Maybe you can close the discussion</P></BODY></HTML> Wed, 02 Nov 2016 19:24:42 GMT https://community.qlik.com/t5/QlikView/minimum-value-if/m-p/1203146#M875082 rupamjyotidas 2016-11-02T19:24:42Z