topic Re: Year Month in QlikView https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019103#M942795 <HTML><HEAD></HEAD><BODY><P>Sunny agreed with you. He asked for function <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">what function should i use.</STRONG></P><P></P><P>And I told him same with some examples<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 18 Jan 2016 13:42:56 GMT Anonymous 2016-01-18T13:42:56Z Year Month https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019098#M942788 <HTML><HEAD></HEAD><BODY><P>Hey ALL,</P><P></P><P>I have a field <SPAN style="text-decoration: underline;"> Year_Month </SPAN> looks like:</P><P><STRONG>Year_Month </STRONG></P><P><STRONG>201311</STRONG></P><P><STRONG>201312</STRONG></P><P><STRONG>201401</STRONG></P><P><STRONG>201402</STRONG></P><P><STRONG>201403</STRONG></P><P><STRONG>201404</STRONG></P><P><STRONG>201405</STRONG></P><P><STRONG>201406</STRONG></P><P><STRONG>201407</STRONG></P><P><STRONG>201408</STRONG></P><P><STRONG>201409</STRONG></P><P><STRONG>201410</STRONG></P><P><STRONG>201411</STRONG></P><P><STRONG>201412</STRONG></P><P><STRONG>201501</STRONG></P><P><STRONG>201502</STRONG></P><P><STRONG>201503</STRONG></P><P><STRONG>201504</STRONG></P><P><STRONG>201505</STRONG></P><P><STRONG>201506</STRONG></P><P><STRONG>201507</STRONG></P><P><STRONG>201508</STRONG></P><P><STRONG>201509</STRONG></P><P><STRONG>201510</STRONG></P><P><STRONG>201511</STRONG></P><P><STRONG>201512</STRONG></P><P><STRONG>if i want to to calculate one year back ei. if i have 201512 i need to see the value ok 201412 what function should i use.</STRONG></P><P></P><P><STRONG>Thank you,</STRONG></P></BODY></HTML> Mon, 18 Jan 2016 13:21:07 GMT https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019098#M942788 mario-sarkis 2016-01-18T13:21:07Z Re: Year Month https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019099#M942789 <HTML><HEAD></HEAD><BODY><P>Can you elaborate of where exactly are you trying to do it? In script? straight table?</P></BODY></HTML> Mon, 18 Jan 2016 13:23:00 GMT https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019099#M942789 sunny_talwar 2016-01-18T13:23:00Z Re: Year Month https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019100#M942790 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You could try something like</P><P></P><P>LEFT(GetFieldSelections(<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Year_Month),4</STRONG>) -1 &amp; <SPAN style="font-size: 13.3333px;">Right(GetFieldSelections(</SPAN><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Year_Month),2</STRONG><SPAN style="font-size: 13.3333px;">)</SPAN></P><P></P><P>Mark</P></BODY></HTML> Mon, 18 Jan 2016 13:29:41 GMT https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019100#M942790 Mark_Little 2016-01-18T13:29:41Z Re: Year Month https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019101#M942791 <HTML><HEAD></HEAD><BODY><P>Use Addmonths() <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>check this as well:</P><P></P><P><A href="https://community.qlik.com/thread/84560">Chart on the last 12 months</A></P><P></P><P><A href="https://community.qlikview.com/thread/57420" title="https://community.qlikview.com/thread/57420">how to show latest 24 months of data in chart? | Qlik Community</A></P><P></P><P><A href="https://community.qlik.com/thread/103553">Display 12 Months (Straight Table)</A></P></BODY></HTML> Mon, 18 Jan 2016 13:33:16 GMT https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019101#M942791 Anonymous 2016-01-18T13:33:16Z Re: Year Month https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019102#M942793 <HTML><HEAD></HEAD><BODY><P>I agree that AddMonths or AddYears is the way to go. But where are we doing this? How can we recommend anything before knowing that <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 18 Jan 2016 13:39:18 GMT https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019102#M942793 sunny_talwar 2016-01-18T13:39:18Z Re: Year Month https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019103#M942795 <HTML><HEAD></HEAD><BODY><P>Sunny agreed with you. He asked for function <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">what function should i use.</STRONG></P><P></P><P>And I told him same with some examples<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 18 Jan 2016 13:42:56 GMT https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019103#M942795 Anonymous 2016-01-18T13:42:56Z Re: Year Month https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019104#M942797 <HTML><HEAD></HEAD><BODY><P>hey sunny&nbsp;&nbsp; i need to use this in the Set analysis part :</P><P>Year_Month={"&gt;=one year back &lt;=max Year_Month"}&gt;}</P><P></P><P>Thank you</P></BODY></HTML> Mon, 18 Jan 2016 14:08:43 GMT https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019104#M942797 mario-sarkis 2016-01-18T14:08:43Z Re: Year Month https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019105#M942799 <HTML><HEAD></HEAD><BODY><P>Assuming Year_Month is a date field, may be this:</P><P></P><P><STRONG>{&lt;Year_Month = {"$(='&gt;='&amp; Date(AddYears(Max(Year_Month), -1), 'YYYYMM') &amp; '&lt;=' &amp; <SPAN style="font-size: 13.3333px;">Date(Max(Year_Month), 'YYYYMM')</SPAN>)"}&gt;}</STRONG></P></BODY></HTML> Mon, 18 Jan 2016 14:19:55 GMT https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019105#M942799 sunny_talwar 2016-01-18T14:19:55Z Re: Year Month https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019106#M942801 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Check this ,</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14531277430991527 jive_text_macro" jivemacro_uid="_14531277430991527"> <P>Temp:</P> <P>LOAD * ,</P> <P>If(Mid(Year_Month,1,4),'2014',2015) as Year,</P> <P>Mid(Year_Month,5,6) as Month</P> <P></P> <P></P> <P>INLINE [</P> <P>Year_Month</P> <P>201311</P> <P>201312</P> <P>201401</P> <P>201402</P> <P>201403</P> <P>201404</P> <P>201405</P> <P>201406</P> <P>201407</P> <P>201408</P> <P>201409</P> <P>201410</P> <P>201411</P> <P>201412</P> <P>201501</P> <P>201502</P> <P>201503</P> <P>201504</P> <P>201505</P> <P>201506</P> <P>201507</P> <P>201508</P> <P>201509</P> <P>201510</P> <P>201511</P> <P>201512</P> <P>];</P> <P></P> <P></P> <P></P> <P></P> <P>Data:</P> <P>Load Year&amp;Month as [Year-Month]</P> <P></P> <P></P> <P>Resident Temp;</P> </PRE><P></P><P><STRONG>output</STRONG>:</P><P><IMG alt="yearmonth.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/111889_yearmonth.PNG" style="height: auto; width: auto;" /></P><P>HTH,</P><P>Hirish</P></BODY></HTML> Mon, 18 Jan 2016 14:37:06 GMT https://community.qlik.com/t5/QlikView/Year-Month/m-p/1019106#M942801 HirisH_V7 2016-01-18T14:37:06Z