topic Re: Dynamic labels in QlikView https://community.qlik.com/t5/QlikView/Dynamic-labels/m-p/1113015#M367866 <HTML><HEAD></HEAD><BODY><P>If your Month-Year values show a numeric representation that represents a date, use QlikView date functions like AddYears():</P><P></P><P>=MonthName(<STRONG>AddYears</STRONG>(Max([Month Period]),-1))</P></BODY></HTML> Sat, 25 Jun 2016 16:59:00 GMT swuehl 2016-06-25T16:59:00Z Dynamic labels https://community.qlik.com/t5/QlikView/Dynamic-labels/m-p/1113014#M367865 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Hi All,</SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">I&nbsp; need dynamic labels. I'm comparing last year current Month VS this year current Month.</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Ex: last&nbsp; May VS current May.</SPAN></P><P></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">May-2016&nbsp;&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">max</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Month Period]</SPAN><SPAN style="font-size: 8pt;">) </SPAN> </SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">How can I get May-2015 .</SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Please help me out.</SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Thanks,</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Krishna.</SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 99px;"><TBODY><TR><TH style="padding: 2px; text-align: center; color: #ffffff; background-color: #6690bc;"><SPAN style="color: #000000;">Month_period</SPAN></TH></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Feb-2014</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Mar-2014</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Apr-2014</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">May-2014</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Jun-2014</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Jul-2014</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Aug-2014</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Sep-2014</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Oct-2014</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Nov-2014</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Dec-2014</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Jan-2015</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Feb-2015</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Mar-2015</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Apr-2015</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">May-2015</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Jun-2015</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Jul-2015</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Aug-2015</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Sep-2015</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Oct-2015</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Nov-2015</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Dec-2015</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Jan-2016</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Feb-2016</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Mar-2016</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">Apr-2016</SPAN></TD></TR><TR><TD align="right" height="17" style="border-width: 0px 0.5pt; border-style: none solid; border-color: #333333 gainsboro; text-align: left; color: #575757; font-family: arial,helvetica,sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);"><SPAN style="color: #333333; font-family: Tahoma;">May-2016</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Sat, 25 Jun 2016 16:49:03 GMT https://community.qlik.com/t5/QlikView/Dynamic-labels/m-p/1113014#M367865 Anonymous 2016-06-25T16:49:03Z Re: Dynamic labels https://community.qlik.com/t5/QlikView/Dynamic-labels/m-p/1113015#M367866 <HTML><HEAD></HEAD><BODY><P>If your Month-Year values show a numeric representation that represents a date, use QlikView date functions like AddYears():</P><P></P><P>=MonthName(<STRONG>AddYears</STRONG>(Max([Month Period]),-1))</P></BODY></HTML> Sat, 25 Jun 2016 16:59:00 GMT https://community.qlik.com/t5/QlikView/Dynamic-labels/m-p/1113015#M367866 swuehl 2016-06-25T16:59:00Z Re: Dynamic labels https://community.qlik.com/t5/QlikView/Dynamic-labels/m-p/1113016#M367867 <HTML><HEAD></HEAD><BODY><P>Thanks Swuehl</P></BODY></HTML> Sat, 25 Jun 2016 17:14:49 GMT https://community.qlik.com/t5/QlikView/Dynamic-labels/m-p/1113016#M367867 Anonymous 2016-06-25T17:14:49Z