topic Max and Min in QlikView https://community.qlik.com/t5/QlikView/Max-and-Min/m-p/911781#M529854 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>How do i highlight max value horizontally and vertically&nbsp; QV table </P><P></P><P></P><P>.<IMG alt="Untitled picture.png" class="jive-image image-1" src="/legacyfs/online/93755_Untitled picture.png" style="height: 72px; width: 620px;" /></P><P></P><P></P><P>Jayanthan</P></BODY></HTML> Thu, 23 Jul 2015 11:09:27 GMT 2015-07-23T11:09:27Z Max and Min https://community.qlik.com/t5/QlikView/Max-and-Min/m-p/911781#M529854 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>How do i highlight max value horizontally and vertically&nbsp; QV table </P><P></P><P></P><P>.<IMG alt="Untitled picture.png" class="jive-image image-1" src="/legacyfs/online/93755_Untitled picture.png" style="height: 72px; width: 620px;" /></P><P></P><P></P><P>Jayanthan</P></BODY></HTML> Thu, 23 Jul 2015 11:09:27 GMT https://community.qlik.com/t5/QlikView/Max-and-Min/m-p/911781#M529854 2015-07-23T11:09:27Z Re: Max and Min https://community.qlik.com/t5/QlikView/Max-and-Min/m-p/911782#M529855 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Can you provide a sample qvw?</P></BODY></HTML> Thu, 23 Jul 2015 11:16:21 GMT https://community.qlik.com/t5/QlikView/Max-and-Min/m-p/911782#M529855 2015-07-23T11:16:21Z Re: Max and Min https://community.qlik.com/t5/QlikView/Max-and-Min/m-p/911783#M529856 <HTML><HEAD></HEAD><BODY><P>In background color</P><P>if(max(total aggr( [yourCelCalc],LOCATION,WSG))=[youCelCalc],lightred())</P><P></P><P>where [yourCelCalc] is the the expression in the cel.</P></BODY></HTML> Thu, 23 Jul 2015 11:31:46 GMT https://community.qlik.com/t5/QlikView/Max-and-Min/m-p/911783#M529856 sgrice 2015-07-23T11:31:46Z Re: Max and Min https://community.qlik.com/t5/QlikView/Max-and-Min/m-p/911784#M529857 <HTML><HEAD></HEAD><BODY><P>Please find attached</P></BODY></HTML> Thu, 23 Jul 2015 11:33:11 GMT https://community.qlik.com/t5/QlikView/Max-and-Min/m-p/911784#M529857 2015-07-23T11:33:11Z Re: Max and Min https://community.qlik.com/t5/QlikView/Max-and-Min/m-p/911785#M529858 <HTML><HEAD></HEAD><BODY><P>If you want to highlight the max and min in the TOTAL its not possible <IMG src="https://community.qlik.com/legacyfs/online/emoticons/plain.png" /></P></BODY></HTML> Thu, 23 Jul 2015 11:40:41 GMT https://community.qlik.com/t5/QlikView/Max-and-Min/m-p/911785#M529858 avinashelite 2015-07-23T11:40:41Z Re: Max and Min https://community.qlik.com/t5/QlikView/Max-and-Min/m-p/911786#M529859 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Vertically:</P><P>For each column, in Background color</P><P><SPAN style="color: #0000ff; font-size: 10pt;">If</SPAN><SPAN style="font-size: 10pt;">(<SPAN style="color: #0000ff;">RangeMax</SPAN>(<SPAN style="color: #0000ff;">Top</SPAN>(<SPAN style="color: #0000ff;">Column</SPAN>(1),1,<SPAN style="color: #0000ff;">NoOfRows</SPAN>()))=<SPAN style="color: #0000ff;">Column</SPAN>(1),<SPAN style="color: #0000ff;">Green</SPAN></SPAN><SPAN style="font-size: 10pt;">()) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">column(2) in 2nd column and so on</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Anrtonio</SPAN></P></BODY></HTML> Thu, 23 Jul 2015 11:55:33 GMT https://community.qlik.com/t5/QlikView/Max-and-Min/m-p/911786#M529859 antoniotiman 2015-07-23T11:55:33Z