topic Re: I need the year for last quarter in QlikView https://community.qlik.com/t5/QlikView/I-need-the-year-for-last-quarter/m-p/1237601#M860811 <HTML><HEAD></HEAD><BODY><P>Can you please elaborate your requirement ?</P></BODY></HTML> Thu, 12 Jan 2017 10:54:38 GMT varshavig12 2017-01-12T10:54:38Z I need the year for last quarter https://community.qlik.com/t5/QlikView/I-need-the-year-for-last-quarter/m-p/1237600#M860810 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I need the year for the last quarter, so I need the year for Q3 "2016" in a expression.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/I-need-the-year-for-last-quarter/m-p/1237600#M860810 Anonymous 2020-11-25T16:16:04Z Re: I need the year for last quarter https://community.qlik.com/t5/QlikView/I-need-the-year-for-last-quarter/m-p/1237601#M860811 <HTML><HEAD></HEAD><BODY><P>Can you please elaborate your requirement ?</P></BODY></HTML> Thu, 12 Jan 2017 10:54:38 GMT https://community.qlik.com/t5/QlikView/I-need-the-year-for-last-quarter/m-p/1237601#M860811 varshavig12 2017-01-12T10:54:38Z Re: I need the year for last quarter https://community.qlik.com/t5/QlikView/I-need-the-year-for-last-quarter/m-p/1237602#M860812 <HTML><HEAD></HEAD><BODY><P>I need a variable expression to tell me what year it was in the previous quarter.&nbsp; We are in Q1 2017 now, last quarter was Q3 2016, I need an expression to hold the value of 2016, and next quarter when we are in Q2 2017, it will hold the value of 2017.</P></BODY></HTML> Thu, 12 Jan 2017 10:57:50 GMT https://community.qlik.com/t5/QlikView/I-need-the-year-for-last-quarter/m-p/1237602#M860812 Anonymous 2017-01-12T10:57:50Z Re: I need the year for last quarter https://community.qlik.com/t5/QlikView/I-need-the-year-for-last-quarter/m-p/1237603#M860813 <HTML><HEAD></HEAD><BODY><P>May be</P><P></P><P><STRONG>=Year(QuarterStart(Today(), -1))</STRONG></P></BODY></HTML> Thu, 12 Jan 2017 10:59:20 GMT https://community.qlik.com/t5/QlikView/I-need-the-year-for-last-quarter/m-p/1237603#M860813 sunny_talwar 2017-01-12T10:59:20Z Re: I need the year for last quarter https://community.qlik.com/t5/QlikView/I-need-the-year-for-last-quarter/m-p/1237604#M860814 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny, I was nearly there, I was leaving the year bit out.</P></BODY></HTML> Thu, 12 Jan 2017 11:01:10 GMT https://community.qlik.com/t5/QlikView/I-need-the-year-for-last-quarter/m-p/1237604#M860814 Anonymous 2017-01-12T11:01:10Z