topic Re: How to show the string by min value in pivot table? in QlikView https://community.qlik.com/t5/QlikView/How-to-show-the-string-by-min-value-in-pivot-table/m-p/545324#M203677 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>see the attched application</P><P></P><P>Regards,</P><P>kush</P></BODY></HTML> Wed, 31 Jul 2013 16:12:46 GMT Kushal_Chawda 2013-07-31T16:12:46Z How to show the string by min value in pivot table? https://community.qlik.com/t5/QlikView/How-to-show-the-string-by-min-value-in-pivot-table/m-p/545321#M203674 <HTML><HEAD></HEAD><BODY><P>LOAD * INLINE [</P><P>Period, Employee, Course, Grade</P><P>2010Q1, Emp1, Cor1, B3</P><P>2010Q1, Emp1, Cor2, A3</P><P>2010Q1, Emp2, Cor1, A2</P><P>2010Q1, Emp2, Cor2, B1</P><P>2010Q2, Emp1, Cor1, A2</P><P>2010Q2, Emp1, Cor2, B2</P><P>2010Q2, Emp2, Cor1, A3</P><P>2010Q2, Emp2, Cor2, A2</P><P>…&nbsp;&nbsp; </P><P>2010Q4, Emp1, Cor1, A1</P><P>2010Q4, Emp1, Cor2, B1</P><P>2010Q4, Emp2, Cor1, A1</P><P>2010Q4, Emp2, Cor2, A3</P><P>];</P><P></P><P>LOAD * INLINE [</P><P>GradeID,Grade</P><P> 1, A1</P><P> 2, A2</P><P> 3, A3</P><P> 4, B1</P><P> 5, B2</P><P> 6, B3</P><P> 7, C1</P><P> 8, C2</P><P> 9, C3</P><P>];</P><P></P><P>I want to get every Grade by min GradeID as below pivot table.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 360px;"><TBODY><TR><TD height="18" width="72"></TD><TD width="72">2010Q1</TD><TD width="72">2010Q2</TD><TD width="72">2010Q3</TD><TD width="72">2010Q4</TD></TR><TR><TD height="18">Emp1</TD><TD>A3</TD><TD>A2</TD><TD>…</TD><TD>A1</TD></TR><TR><TD height="18">Emp2</TD><TD>A2</TD><TD>A3</TD><TD>…</TD><TD>A3</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 31 Jul 2013 14:39:16 GMT https://community.qlik.com/t5/QlikView/How-to-show-the-string-by-min-value-in-pivot-table/m-p/545321#M203674 Anonymous 2013-07-31T14:39:16Z Re: How to show the string by min value in pivot table? https://community.qlik.com/t5/QlikView/How-to-show-the-string-by-min-value-in-pivot-table/m-p/545322#M203675 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use FirstSortedValue for this case</P><P>=FirstSortedValue(Grade,GradeID)</P><P></P><P>Hope It helps</P><P></P><P>Celambarasan</P></BODY></HTML> Wed, 31 Jul 2013 14:53:29 GMT https://community.qlik.com/t5/QlikView/How-to-show-the-string-by-min-value-in-pivot-table/m-p/545322#M203675 CELAMBARASAN 2013-07-31T14:53:29Z Re: How to show the string by min value in pivot table? https://community.qlik.com/t5/QlikView/How-to-show-the-string-by-min-value-in-pivot-table/m-p/545323#M203676 <HTML><HEAD></HEAD><BODY><P>Either your example is not accurate or I'm wrong, but the min for Emp2 for 2010Q4 is A1 and not A3.</P><P></P><P>Check the app. I hope it helps.</P></BODY></HTML> Wed, 31 Jul 2013 15:30:27 GMT https://community.qlik.com/t5/QlikView/How-to-show-the-string-by-min-value-in-pivot-table/m-p/545323#M203676 jvitantonio 2013-07-31T15:30:27Z Re: How to show the string by min value in pivot table? https://community.qlik.com/t5/QlikView/How-to-show-the-string-by-min-value-in-pivot-table/m-p/545324#M203677 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>see the attched application</P><P></P><P>Regards,</P><P>kush</P></BODY></HTML> Wed, 31 Jul 2013 16:12:46 GMT https://community.qlik.com/t5/QlikView/How-to-show-the-string-by-min-value-in-pivot-table/m-p/545324#M203677 Kushal_Chawda 2013-07-31T16:12:46Z Re: How to show the string by min value in pivot table? https://community.qlik.com/t5/QlikView/How-to-show-the-string-by-min-value-in-pivot-table/m-p/545325#M203678 <HTML><HEAD></HEAD><BODY><P>Thank you kush. That is just exactly what I need. </P></BODY></HTML> Thu, 01 Aug 2013 00:46:52 GMT https://community.qlik.com/t5/QlikView/How-to-show-the-string-by-min-value-in-pivot-table/m-p/545325#M203678 Anonymous 2013-08-01T00:46:52Z