topic Re: getting maximum value.. in QlikView https://community.qlik.com/t5/QlikView/getting-maximum-value/m-p/410196#M152589 <HTML><HEAD></HEAD><BODY><P>'<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">CURRENT STOCK AVAILABLE AS ON</SPAN>' <SPAN style="font-size: 10pt;"> &amp; upper(Firstsortedvalue(month, -time_id)) &amp; '-' &amp; Firstsortedvalue(year, -time_id)</SPAN></P></BODY></HTML> Tue, 05 Mar 2013 18:26:10 GMT Gysbert_Wassenaar 2013-03-05T18:26:10Z getting maximum value.. https://community.qlik.com/t5/QlikView/getting-maximum-value/m-p/410195#M152588 <HTML><HEAD></HEAD><BODY><P>AOA</P><P></P><P>i have dimension of time having field of </P><P>(time_id,month,qtr,year)</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="114" style="width: 158px; border: 1px solid rgb(0, 0, 0); height: 89px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">time_id<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">month<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">qtr<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">year<BR /></TH></TR><TR><TD>669</TD><TD>dec</TD><TD>4</TD><TD>2012</TD></TR><TR><TD>670</TD><TD>jan</TD><TD>1</TD><TD>2013</TD></TR><TR><TD>671</TD><TD>feb</TD><TD>1</TD><TD>2013</TD></TR><TR><TD>672</TD><TD>mar</TD><TD>1</TD><TD>2013</TD></TR></TBODY></TABLE><P></P><P>also have cube of stock......</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="114" style="width: 321px; border: 1px solid #000000; height: 33px;" width="319"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">partno<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>item</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle">time_id<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">qty in stock<BR /></TH></TR><TR><TD>12-2-2-2</TD><TD>chair</TD><TD>671</TD><TD>50</TD></TR><TR><TD>12-2-3-2</TD><TD>computer</TD><TD>672</TD><TD>12</TD></TR><TR><TD>12-2-3-2</TD><TD>computer</TD><TD>671</TD><TD>8</TD></TR><TR><TD>12-3-3-3</TD><TD>mouse</TD><TD>669</TD><TD>2</TD></TR></TBODY></TABLE><P></P><P>now is a current stock sheet i want to show heading "CURRENT STOCK AVAILABLE AS ON MAR-2013"</P><P>where MAR-2013 is a dynamic field which is a month and year of maximum time id </P><P></P><P>how can i get month and year of maximum time id in a text box to dispaly the required heading.&nbsp; plz advice</P></BODY></HTML> Tue, 05 Mar 2013 18:18:48 GMT https://community.qlik.com/t5/QlikView/getting-maximum-value/m-p/410195#M152588 2013-03-05T18:18:48Z Re: getting maximum value.. https://community.qlik.com/t5/QlikView/getting-maximum-value/m-p/410196#M152589 <HTML><HEAD></HEAD><BODY><P>'<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">CURRENT STOCK AVAILABLE AS ON</SPAN>' <SPAN style="font-size: 10pt;"> &amp; upper(Firstsortedvalue(month, -time_id)) &amp; '-' &amp; Firstsortedvalue(year, -time_id)</SPAN></P></BODY></HTML> Tue, 05 Mar 2013 18:26:10 GMT https://community.qlik.com/t5/QlikView/getting-maximum-value/m-p/410196#M152589 Gysbert_Wassenaar 2013-03-05T18:26:10Z