topic Re: Expression in QlikView https://community.qlik.com/t5/QlikView/Expression/m-p/831581#M1000830 <HTML><HEAD></HEAD><BODY><P>Try this expression with ID as your Dimension:</P><P></P><P><STRONG>=Avg(If(Aggr(Min(No), ID) = No, Payment))</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/88405_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 04 Jun 2015 14:44:22 GMT sunny_talwar 2015-06-04T14:44:22Z Expression https://community.qlik.com/t5/QlikView/Expression/m-p/831580#M1000828 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can someone please help me with this requirement.</P><P></P><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Payment</P><P>10000&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4000<BR />10000&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500<BR />10000&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50<BR />10000&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000</P><P></P><P>I want to display Payment as 4000 for ID = 10000, since 3 is the min(Num).<BR />How can I do this at expression level.</P><P></P><P>Thanks in advance.</P><P></P><P>Regards,</P><P>Adi</P></BODY></HTML> Thu, 04 Jun 2015 14:32:16 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/831580#M1000828 2015-06-04T14:32:16Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/831581#M1000830 <HTML><HEAD></HEAD><BODY><P>Try this expression with ID as your Dimension:</P><P></P><P><STRONG>=Avg(If(Aggr(Min(No), ID) = No, Payment))</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/88405_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 04 Jun 2015 14:44:22 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/831581#M1000830 sunny_talwar 2015-06-04T14:44:22Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/831582#M1000831 <HTML><HEAD></HEAD><BODY><P>FirstSortedValue(Payment, No)</P></BODY></HTML> Thu, 04 Jun 2015 14:47:55 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/831582#M1000831 maxgro 2015-06-04T14:47:55Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/831583#M1000832 <HTML><HEAD></HEAD><BODY><P>Thank u Massimo!!</P></BODY></HTML> Thu, 04 Jun 2015 14:52:07 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/831583#M1000832 2015-06-04T14:52:07Z