topic Smallest value per dimension-element in QlikView https://community.qlik.com/t5/QlikView/Smallest-value-per-dimension-element/m-p/261999#M1204138 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Perhaps not the best of the expressions but would solve your problem</P><P>Add Product &amp; Seller in dimensions and in the expression write</P><P>= if ( min(total &lt; Product&gt; Price) - Price &lt; 0 , 0, Price)</P><P>Now supress Zero values in the presentaitons Tab and it works</P><P>Again not the ideal solution I guess</P></BODY></HTML> Wed, 16 Jun 2010 08:53:35 GMT 2010-06-16T08:53:35Z Smallest value per dimension-element https://community.qlik.com/t5/QlikView/Smallest-value-per-dimension-element/m-p/261998#M1204137 <HTML><HEAD></HEAD><BODY><P></P><P>Hi,</P><P>I have the following problem:</P><HR /><P>Source-Table is</P><P>Seller | Product | Price</P><P>S1 | P1 | 3.09</P><P>S1 | P2 | 3.29</P><P>S1 | P3 | 6.09</P><P>S2 | P1 | 2.99</P><P>S2 | P2 | 3,49</P><P>S2 | P3 | 5.39</P><P>S3 | P1 | 3.19</P><P>S3 | P2 | 2.59</P><P>S3 | P3 | 6,49</P><P></P><P>Desired Table with best price per product</P><P>Seller | Product | Price</P><P>S2 | P1 | 2.99</P><P>S3 | P2 | 2.59</P><P>S2 | P3 | 5.39</P><HR /><P>How can I solve this? Maybe a question of designing the formula.</P><P>Thanks</P><DIV></DIV><P></P></BODY></HTML> Wed, 16 Jun 2010 08:24:11 GMT https://community.qlik.com/t5/QlikView/Smallest-value-per-dimension-element/m-p/261998#M1204137 2010-06-16T08:24:11Z Smallest value per dimension-element https://community.qlik.com/t5/QlikView/Smallest-value-per-dimension-element/m-p/261999#M1204138 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Perhaps not the best of the expressions but would solve your problem</P><P>Add Product &amp; Seller in dimensions and in the expression write</P><P>= if ( min(total &lt; Product&gt; Price) - Price &lt; 0 , 0, Price)</P><P>Now supress Zero values in the presentaitons Tab and it works</P><P>Again not the ideal solution I guess</P></BODY></HTML> Wed, 16 Jun 2010 08:53:35 GMT https://community.qlik.com/t5/QlikView/Smallest-value-per-dimension-element/m-p/261999#M1204138 2010-06-16T08:53:35Z AW:Re: Smallest value per dimension-element https://community.qlik.com/t5/QlikView/Smallest-value-per-dimension-element/m-p/262000#M1204139 <HTML><HEAD></HEAD><BODY><P>It works ! <IMG alt="Big Smile" src="http://community.qlik.com/emoticons/emotion-2.gif" /></P><P>Thank you Umang</P></BODY></HTML> Wed, 16 Jun 2010 11:45:35 GMT https://community.qlik.com/t5/QlikView/Smallest-value-per-dimension-element/m-p/262000#M1204139 2010-06-16T11:45:35Z