topic Re: how to pick up max value from 4 different fields .. in QlikView https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507978#M189883 <HTML><HEAD></HEAD><BODY><P>In a chart?</P><P>max(TOTAL RangeMax(f1,f2,f3,f4))</P><P></P><P><IMG alt="102378.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/50672_102378.jpg" style="width: auto; height: auto;" /></P></BODY></HTML> Thu, 19 Dec 2013 12:23:01 GMT maxgro 2013-12-19T12:23:01Z how to pick up max value from 4 different fields .. https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507977#M189882 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>how to pick up max value from 4 different fields&nbsp; by comparing them&nbsp; with each&nbsp; other</P><P></P><P>i want to pick up value from this field which is maximum </P><P></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">field</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG><SPAN style="color: #ffffff; text-align: center; background-color: #6690bc;">field </SPAN>2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG><SPAN style="color: #ffffff; text-align: center; background-color: #6690bc;">field </SPAN>3 </STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG><SPAN style="color: #ffffff; text-align: center; background-color: #6690bc;">field </SPAN>4</STRONG></TH></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">60</TD></TR><TR><TD style="padding: 2px;">70</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">60</TD><TD style="padding: 2px;">90</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 19 Dec 2013 11:45:39 GMT https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507977#M189882 2013-12-19T11:45:39Z Re: how to pick up max value from 4 different fields .. https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507978#M189883 <HTML><HEAD></HEAD><BODY><P>In a chart?</P><P>max(TOTAL RangeMax(f1,f2,f3,f4))</P><P></P><P><IMG alt="102378.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/50672_102378.jpg" style="width: auto; height: auto;" /></P></BODY></HTML> Thu, 19 Dec 2013 12:23:01 GMT https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507978#M189883 maxgro 2013-12-19T12:23:01Z Re: how to pick up max value from 4 different fields .. https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507979#M189884 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I reckon you should remove TOTAL to get the max for each line</P><P></P><P>max(RangeMax(f1,f2,f3,f4))</P><P></P><P></P><P>Chris</P></BODY></HTML> Thu, 19 Dec 2013 12:25:58 GMT https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507979#M189884 2013-12-19T12:25:58Z Re: how to pick up max value from 4 different fields .. https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507980#M189885 <HTML><HEAD></HEAD><BODY><P>Yes if&nbsp; he wants the max at row level</P></BODY></HTML> Thu, 19 Dec 2013 12:28:06 GMT https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507980#M189885 maxgro 2013-12-19T12:28:06Z Re: how to pick up max value from 4 different fields .. https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507981#M189886 <HTML><HEAD></HEAD><BODY><P>and rangemax works in script too</P><P></P><P>load</P><P>d,f1,f2,f3,f4,RangeMax(f1,f2,f3,f4);</P><P>LOAD * INLINE [</P><P>d,f1,f2,f3,f4</P><P>a,100, 200, 50, 60</P><P>b,70, 20, 60, 90</P><P>];</P></BODY></HTML> Thu, 19 Dec 2013 12:31:23 GMT https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507981#M189886 maxgro 2013-12-19T12:31:23Z Re: how to pick up max value from 4 different fields .. https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507982#M189887 <HTML><HEAD></HEAD><BODY><P>Thanks for your replay</P><P></P><P>For easy Way to solve this</P><P></P><P>before this i have done it&nbsp; by using if&nbsp; </P><P>but your way is easy way to it</P></BODY></HTML> Fri, 20 Dec 2013 06:10:41 GMT https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507982#M189887 2013-12-20T06:10:41Z Re: how to pick up max value from 4 different fields .. https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507983#M189888 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Christen in above Example&nbsp; suppose that i want field name not field value after comparison </P><P></P><P>how can i do that</P></BODY></HTML> Mon, 23 Dec 2013 06:42:26 GMT https://community.qlik.com/t5/QlikView/how-to-pick-up-max-value-from-4-different-fields/m-p/507983#M189888 2013-12-23T06:42:26Z