topic Max value of dimension based on expression in QlikView https://community.qlik.com/t5/QlikView/Max-value-of-dimension-based-on-expression/m-p/864699#M1001970 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement, where I am showing the highest, 2nd highest, 3rd highest and worst value across a dimension (Date) and based on the selected time period. Now I also need to show the dates for when the above values correspond. This is all done on the UI and not the load script due to data restrictions. </P><P></P><P>Can someone please suggest a way to achieve this? Example shown below:</P><P></P><P>Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04-May&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05-May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04-MAY&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05-May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04-May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04-May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -10</P><P></P><P>So the result will be:</P><P></P><P>Type&nbsp;&nbsp;&nbsp;&nbsp; Highest&nbsp;&nbsp;&nbsp;&nbsp; Highest Date 2nd Highest&nbsp;&nbsp;&nbsp;&nbsp; 2nd Highest Date</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05-May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04-May</P></BODY></HTML> Wed, 10 Jun 2015 12:01:12 GMT 2015-06-10T12:01:12Z Max value of dimension based on expression https://community.qlik.com/t5/QlikView/Max-value-of-dimension-based-on-expression/m-p/864699#M1001970 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement, where I am showing the highest, 2nd highest, 3rd highest and worst value across a dimension (Date) and based on the selected time period. Now I also need to show the dates for when the above values correspond. This is all done on the UI and not the load script due to data restrictions. </P><P></P><P>Can someone please suggest a way to achieve this? Example shown below:</P><P></P><P>Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04-May&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05-May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04-MAY&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05-May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04-May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04-May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -10</P><P></P><P>So the result will be:</P><P></P><P>Type&nbsp;&nbsp;&nbsp;&nbsp; Highest&nbsp;&nbsp;&nbsp;&nbsp; Highest Date 2nd Highest&nbsp;&nbsp;&nbsp;&nbsp; 2nd Highest Date</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05-May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04-May</P></BODY></HTML> Wed, 10 Jun 2015 12:01:12 GMT https://community.qlik.com/t5/QlikView/Max-value-of-dimension-based-on-expression/m-p/864699#M1001970 2015-06-10T12:01:12Z Re: Max value of dimension based on expression https://community.qlik.com/t5/QlikView/Max-value-of-dimension-based-on-expression/m-p/864700#M1001971 <HTML><HEAD></HEAD><BODY><P>See if this helps</P></BODY></HTML> Wed, 10 Jun 2015 15:57:57 GMT https://community.qlik.com/t5/QlikView/Max-value-of-dimension-based-on-expression/m-p/864700#M1001971 santhoo_san 2015-06-10T15:57:57Z