topic Find Key with min value and calc average value with that key in QlikView https://community.qlik.com/t5/QlikView/Find-Key-with-min-value-and-calc-average-value-with-that-key/m-p/331458#M494087 <HTML><HEAD></HEAD><BODY><DIV>Need help ))</DIV><DIV> </DIV><DIV>I want to find min value in a table, than find a key for that value and after find average value for that key</DIV><DIV>i thought this is common taks but failed to find an answer</DIV><DIV> </DIV><DIV>1/ Variable to find key with min value</DIV><DIV><SPAN style="font-size: 8pt;"><DIV>MinString({$&lt;HotelCost = {$(=Min(HotelCost))}&gt;} RoomCategoryName) </DIV><SPAN style="font-size: 8pt;"><DIV> </DIV></SPAN>Then i put this in expressions<BR /><SPAN style="font-size: 8pt;">=$(vHotelBaseRoom)<BR /></SPAN></SPAN></DIV><DIV>2/&nbsp; Then i try to calc average value with that key<SPAN style="font-size: 8pt;"><DIV>=Avg({$&lt;RoomCategoryName={$(=$(vHotelBaseRoom))}}&gt;} HotelCost) </DIV><DIV> </DIV><SPAN style="font-size: 8pt;"><DIV> </DIV></SPAN><SPAN style="font-size: 8pt;"> </SPAN>Receive NULL</SPAN></DIV></BODY></HTML> Wed, 02 May 2012 11:08:48 GMT 2012-05-02T11:08:48Z Find Key with min value and calc average value with that key https://community.qlik.com/t5/QlikView/Find-Key-with-min-value-and-calc-average-value-with-that-key/m-p/331458#M494087 <HTML><HEAD></HEAD><BODY><DIV>Need help ))</DIV><DIV> </DIV><DIV>I want to find min value in a table, than find a key for that value and after find average value for that key</DIV><DIV>i thought this is common taks but failed to find an answer</DIV><DIV> </DIV><DIV>1/ Variable to find key with min value</DIV><DIV><SPAN style="font-size: 8pt;"><DIV>MinString({$&lt;HotelCost = {$(=Min(HotelCost))}&gt;} RoomCategoryName) </DIV><SPAN style="font-size: 8pt;"><DIV> </DIV></SPAN>Then i put this in expressions<BR /><SPAN style="font-size: 8pt;">=$(vHotelBaseRoom)<BR /></SPAN></SPAN></DIV><DIV>2/&nbsp; Then i try to calc average value with that key<SPAN style="font-size: 8pt;"><DIV>=Avg({$&lt;RoomCategoryName={$(=$(vHotelBaseRoom))}}&gt;} HotelCost) </DIV><DIV> </DIV><SPAN style="font-size: 8pt;"><DIV> </DIV></SPAN><SPAN style="font-size: 8pt;"> </SPAN>Receive NULL</SPAN></DIV></BODY></HTML> Wed, 02 May 2012 11:08:48 GMT https://community.qlik.com/t5/QlikView/Find-Key-with-min-value-and-calc-average-value-with-that-key/m-p/331458#M494087 2012-05-02T11:08:48Z Find Key with min value and calc average value with that key https://community.qlik.com/t5/QlikView/Find-Key-with-min-value-and-calc-average-value-with-that-key/m-p/331459#M494088 <HTML><HEAD></HEAD><BODY><P> Dear all, I found an answer for my problem by myself - Subset does not include current row context - that's why when i apply variable - i find min price room name <BR />but this room name is not for this hotel and then i dont get anything</P><P></P><P>So i found my error - if you want to find minimum using this context then you nee to use if else expression</P><P><SPAN style="font-size: 8pt;"> </SPAN></P></BODY></HTML> Thu, 10 May 2012 16:06:35 GMT https://community.qlik.com/t5/QlikView/Find-Key-with-min-value-and-calc-average-value-with-that-key/m-p/331459#M494088 2012-05-10T16:06:35Z