topic Calculated Dimension for YearQTR in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-YearQTR/m-p/395052#M147363 <HTML><HEAD></HEAD><BODY><P>Hi All-hope someone can help me on this.I have a dimension called <STRONG>'current YrQtr' </STRONG>which returns value 2012Q3 for <STRONG>Nov</STRONG>.I need a calculated dimension which should return current qtr along with three previous qtrs.</P><P></P><P>Final result should be </P><P></P><P>2012Q3,2012Q2,2012Q1 and 2011Q4.</P><P></P><P></P><P>Thanks-pooja</P></BODY></HTML> Fri, 30 Nov 2012 16:40:52 GMT 2012-11-30T16:40:52Z Calculated Dimension for YearQTR https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-YearQTR/m-p/395052#M147363 <HTML><HEAD></HEAD><BODY><P>Hi All-hope someone can help me on this.I have a dimension called <STRONG>'current YrQtr' </STRONG>which returns value 2012Q3 for <STRONG>Nov</STRONG>.I need a calculated dimension which should return current qtr along with three previous qtrs.</P><P></P><P>Final result should be </P><P></P><P>2012Q3,2012Q2,2012Q1 and 2011Q4.</P><P></P><P></P><P>Thanks-pooja</P></BODY></HTML> Fri, 30 Nov 2012 16:40:52 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-YearQTR/m-p/395052#M147363 2012-11-30T16:40:52Z Re: Calculated Dimension for YearQTR https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-YearQTR/m-p/395053#M147364 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Due to have date field? if so,</P><P></P><P>Try like this</P><P></P><P>=sum({&lt;Date = {'&gt;=$(=Monthstart(AddMonths(today(),-12)))&lt;=$(=Today())'}&gt;}Sales)</P><P></P><P>Calculate last 12 month from today..</P><P></P><P>Hope it helps</P></BODY></HTML> Fri, 30 Nov 2012 16:53:48 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-YearQTR/m-p/395053#M147364 MayilVahanan 2012-11-30T16:53:48Z Re: Calculated Dimension for YearQTR https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-YearQTR/m-p/395054#M147365 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply.Objective is to have a calculated dimension that can dispaly 4 qtrs(current qtr and 3 previous qtrs).I am not worried about expression.</P><P><IMG __jive_id="25916" class="jive-image" alt="QTR.png" src="https://community.qlik.com/legacyfs/online/25916_QTR.png" /></P></BODY></HTML> Fri, 30 Nov 2012 17:07:17 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-YearQTR/m-p/395054#M147365 2012-11-30T17:07:17Z Re: Calculated Dimension for YearQTR https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-YearQTR/m-p/395055#M147366 <HTML><HEAD></HEAD><BODY><P>HI </P><P></P><P> Use <STRONG>current YrQtr as </STRONG>dimension and then use the above epression. if you have datefield..</P><P></P><P>Can you post a sample file/</P></BODY></HTML> Fri, 30 Nov 2012 17:57:50 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-YearQTR/m-p/395055#M147366 MayilVahanan 2012-11-30T17:57:50Z